How do I view the Top SQL statements in Performance Analysis 6.1?
To view the Top SQL statements in Performance Analysis (PA) 6.1, perform the following steps:
1) Launch PA and click on "History".
2) Expand the "Instance View" on the tree on the left pane.
3) Click on "SQL Statements".
4) Click on the "Tops" tab under the graphical view. The top SQL statements will be shown.
The SQL statements can be sorted by any of the columns by clicking on the column name, e.g. "Active Time", "CPU Usage", etc.