Tops Tab
In accordance with the dimension filter, the most resource demanding elements for the specified dimension are displayed and sorted, according to the selected resource. (Available when dimension nodes within the Instance View are in the active focus.)
The Tops graphical display contains the overall Resource activity in accordance with the defining Dimension Filter. Clicking on a dimension value within the Tops pane listing displays its portion of the total resource activity in the graphic display above it. Thus you can readily see its usage as a portion of the total, over time. In this manner you can determine more fully this element’s behavior pattern over the entire period of interest, including mutual effects of several entities on total activity.
The combination of top pane-listings of the entire period and a graphical view over the period lets you distinguish between elements whose resource usage is monotonous and elements with anomalous behavior (which are more likely to be causing bottlenecks).
To investigate behavior other than the default resource usage, use the drop-down listing in the graphical portion to focus on the different metrics. The metrics are those which are relevant to the displayed resource. The change of metrics does not alter the pane element listing, which are dependent solely on the resource selection.
Double clicking a tops entry drills down into it and causes it to be a focus of activity.
Note: The displayed dimension listing of top resource consuming entries is sorted based on the selected Resource. Thus the pane listing will differ for a given period, depending on the Resource selection in effect.
To configure the default number of Tops displays, see Performance Analysis Configuration.
SQL Filtering
Performance Analysis offers a filtering feature to limit display in the right pane listing to only those dimensions matching a set of user-defined expression conditions. When the left tree-node focus is on a dimension, use the Click to create... hyperlink to launch the Filter Definition dialog wherein you can construct, modify and delete a filter set composed of three part expressions (predicates):
Field - The current dimension selected or any of the displayed Oracle wait event performance metrics
Condition
Dimension - contains, does not contain, begins with, ends with, or is
Oracle wait event metric - =, <>, >=, >, <=, or <
Value - a valid character string or numeric value for the specified field