Tech Tip on Tracing database operations
By Gopal Jorapur on Jul 15, 2008
We do see lot of performance bottlenecks in database operations. Tracing these botttlenecks is an important task in optimizing database operations. This information can help you fine tune the database calls that the application makes and in this way improve the application's performance. This Tech Tip from Jagadish will help demonstrate how to use a tool called P6SPY to trace the database requests issued by an application running with the GlassFish v2 application server. Here we learn how to trace SQL statements from an application that uses GlassFish's JDBC Connection Pool.