Tops
The Tops report displays the most offensive Oracle activities (dimensions) for a given time frame, like that of the Performance Analysis' historical tops view.
The Tops Reports wizard has four defining windows:
Dimensions - Include in your report template the entire Instance Level activity or a subset (Specify Activity Filter) of historical (up to three) Dimension data.
Metrics
Select Metrics for Resource: Select here the resource for display as the upper graph. The most resource demanding elements for the specified dimension are displayed and sorted, according to the selected resource. The chosen resource determines which metrics are available for the other presentations in the report.
Show Top <number> <dimensions>: Determines the number of top dimension activities to be displayed. For example, display top five SQL statements.
Sorted By:Determines the metric by the top results will be sorted (though not selected as the selection is according to the selected resource). The default is always according to the selected resource.
Select from among the potential metric subset those that will appear in the table for each time unit in the reporting period.
Time Range - Select here a Predefined Time Range of a system default or a user-defined permanent range; or define one here by means of a Specific Time Range. Also, specify the data Interval resolution.
Summary
Create a textual:
Report Description - An optional user-input for referencing and clarification. Useful when saving the report template.
Report name - An optional user-input for referencing and clarification. Mandatory for saving, this report will be added to and stored with the existing list under this name.
File name - Name of the report file template. A recommended default is suggested.
Click Save to save the template for subsequent executions.
Use Preferences to select
your totaling method where the report data is to be displayed
if you want to expand the dimension column width or replace the dimensions value with the legend (useful when dimension values are long, as in SQL statements)
if SQL texts are to be printed with full colors.
Use Schedule to set the periodic Schedule and Delivery Options for this report's execution and archiving.
The report may be either: previewed on the window, printed, or stored in Performance Analysis.