BMC Software, Inc., Confidential and Proprietary Information
Menu Summary C-19
BEAWLS_DBURL Application Menu
The menu commands in Table C-15 are the PATROL KM menu
commands at the BEAWLS_DBURL top level of the menu tree
hierarchy.
BEAWLS_SQL Application Menu
The menu commands in Table C-16 are the PATROL KM menu
commands at the BEAWLS_SQL top level of the menu tree hierarchy.
Table C-15 BEAWLS_DBURL commands
Menu Command Action
Report Top N SQL identify the most resource-intensive SQL statements (the
number of results returned can be set from 1 to 30); this query
returns a list of SQL queries with the longest average
response time, the longest total response time, and most often
used (highest number of invocations); this command reports
results for only a specific database URL, if you want results to
span URLs, run this command from the SERVER or
LOCAL_MANAGED icon
Select SQL for Monitoring use this command to select specific SQL queries (up to 30
instances) for monitoring; you can define a unique label (alias)
that will be used as the name for a spawned instance of the
BEAWLS_SQL class
Table C-16 BEAWLS_SQL commands
Menu Command Action
Display SQL Statement shows details of the SQL statement represented by this
instance of the BEAWLS_SQL class
Stop Monitoring stops collecting detailed performance information for this SQL
statement and removes this SQL instance from the console
