Top N Performance
Click [Analysis] > [Performance Analysis] > [Top N Performance] in the global navigation bar to open the Top N Performance screen.
In the Top N Performance screen, the users can view the top SQL statements during the search period.
When the users set the Category and Item, the users can view the Value for the selected Item. Additionally, selecting a value in the Category and double-clicking it allows the users to view information about the SQL, and selecting an SQL and double-clicking it links to the SQL Detail screen.
The following is a description of each area in the tab screen.
Category
Data aggregation criteria include 'Machine', 'Module', 'Program', 'Username', and 'OS user'. When 'SQL' is selected, no aggregation criteria are set.
Item
Aggregation items include 'Logical Reads', 'Physical Reads', 'Redo Entries', 'Execute Count', etc.
Category / {CATEGORY}
By selecting Category and Item, the users can view performance metrics for the monitoring period. At this time, the users can specify the number of items in the sort list (ALL / Top 20 / Top 30 / Top 50) for categories other than SQL Category using the combo box in the upper-right corner of the area.
The following is a description of the items provided in the Category / Module area.
Module
Information about the value selected in Category– Module: Module name – Program: Program name – Username: Database user name – OS user: OS user name – Machine: Control DB hostname
Value
Total for the selected criteria (Category, Item)
Ratio (%)
Usage ratio for each item
{ITEM} / SQL
Displays SQL statements from the Category / Module with the highest Item (Logical Reads) values in descending order. Double-clicking on a SQL statement takes the users to the SQL Detail screen.
The following is a description of the items provided in the MODULE / SQL area.
SQL ID | Child Number
SQL ID and Child Number of the SQL
SQL Text
SQL Syntax
Value
Values for the selected criteria (Category, Item) for each SQL
Ratio(%)
Ratio by SQL
Last updated