BMC Software, Inc., Confidential and Proprietary Information
C-12 PATROL for BEA WebLogic User Guide
BEAWLS_JDBC Application Menu
The menu commands in Table C-9 are the PATROL KM menu
commands at the BEAWLS_JDBC top level of the menu tree hierarchy.
Table C-9 BEAWLS_JDBC Application Menu Summary (Part 1 of 2)
Menu Command Action
Profiling Reports
SQL Roundtrip displays SQL statement text, execution time, start and end
time, and transaction name of the SQL statement
Connection Leak displays connection leak profile, including stack trace at the
time the connection was created (which allows the location
of the leak to be identified)
connection leaks occur when a pool closes without an
explicit close() call and then garbage collection occurs
Prepared Statement Cache displays cache snapshots stored externally for later analysis;
this contains an array for the number of hits on a
corresponding SQL statement, the text of a cached SQL
statement, and the time that the prepared statement cache
was created
Profile Settings
Enable Statement Profiling turns on SQL statement profiling
when turned on, this will generate details about all SQL
statements and their execution data
this command is resource intensive and should be used only
as long as necessary; using SQL profiling for long periods of
time can degrade overall performance
Disable Statement Profiling turn off SQL statement profiling
Enable Conn Leak Profiling turns on connection leak profiling
when enabled, profile information is created if connection
leaks occur; the profile information provides details about the
leak occurrence and can be viewed using the Connection
Leak report, as described under “Profiling Reports” below
Disable Conn Leak Profiling turns off generation of connection leak profile data
