BMC Software, Inc., Confidential and Proprietary Information
9-4 PATROL for BEA WebLogic User Guide
Running the Top N SQL Report
Summary: Run a report to identify which SQL statements are used most often on
your WebLogic servers.
You can use this information to decide which SQL objects should be
watched more closely, and you can identify web applications, servlets,
and methods that call your most used or most resource-intensive SQL.
You can run the report for one specific database URL by using the
command from the DBURL icon, or you can run the report to obtain data
for all database URLs on the server by using the command from the
server instance icon.
To run the Top N SQL report:
Step 1
Right-click the server instance icon or the DBURL instance icon.
Step 2 From the KM Commands, choose Advance Monitoring => Report Top N
SQL
.
The dialog is displayed.
Step 3 Select the checkbox for the criterion you want used to determine “top”
SQL, then slide the control to indicate the number of results you want.
Step 4 Click OK.
