BMC Software, Inc., Confidential and Proprietary Information
Managing WebLogic Components and Services 7-19
Generating JDBC Profiling Reports
Summary: Perform these steps to generate a report of JDBC profile data.
Three types of profile report can be generated:
•
Statement profile: reports details about all SQL statements and their
execution data.
•
Connection leak profile: if connection leaks occur, reports detailed
information about the occurrence.
•
Prepared statement profile: reports details about the usage of cached
prepared SQL statements.
Note
Generating JDBC profile reports requires that profiling be enabled. See
“Enabling or Disabling JDBC Profiling” on page 7-18.
To run the profile reports:
Step 1
Right-click the instance icon of the pool for which you
want profile reports.
Step 2 From the KM Commands menu, choose the command that reports on the
type of profiling data in which you are interested. The commands are:
• Profiling Reports => SQL Roundtrip
• Profiling Reports => Connection Leak
• Profiling Reports => Prepared Statement Cache
The report is displayed in a task output window.
