BMC Software, Inc., Confidential and Proprietary Information
7-18 PATROL for BEA WebLogic User Guide
Enabling or Disabling JDBC Profiling
Summary: Perform these steps to turn on or off the collection of various types of
JDBC profile information.
Three types of profile information can be collected:
•
Statement profiling: generates details about all SQL statements and
their execution data.
•
Connection leak profiling: if connection leaks occur, detailed
information about the occurrence is saved.
•
Prepared statement profiling: generates details about the usage of
cached prepared SQL statements.
Note
Collecting statement profile or prepared statement profile information is
resource intensive and will degrade system performance if used
excessively. Profiling should be disabled when not needed for diagnostic
purposes.
To turn on or turn off profiling:
Step 1
Right-click the instance icon of the pool for which you
want profile information turned on or off.
Step 2 From the KM Commands menu, choose Profile Settings.
Step 3 Choose the command to enable or disable the collection of a type of
profile data.
