BMC Software, Inc., Confidential and Proprietary Information
9-6 PATROL for BEA WebLogic User Guide
Monitoring SQL Objects
Summary: Monitor selected SQL objects.
SQL objects are not monitored by default because there are far too many
of them and the objects of critical importance are specific to your own
environment. If you are unsure which SQL objects are most important in
your environment, start with the objects with the slowest performance or
those most called by applications running in your environment. See
“Running the Top N SQL Report” on page 9-4 to find these SQL.
To monitor SQL:
Step 1
Right-click a DBURL instance icon.
Step 2 From the KM Commands menu, choose Select SQL for Monitoring.
The Specify Top SQL dialog box appears.
Step 3 Click the box next to the criteria you want to use for determining “top”
SQL, then slide the bar to the number of responses you want.
Step 4 Click OK.
The Select the SQL dialog appears.
Step 5 Select the SQL you want monitored from the list of “top” SQL objects.
