Activity
The Activity report traces the activity and impact of a certain Oracle entity in a specific time frame. The report is modeled on the Performance Analysis historical diagnostics windows and gives an overview of behavior of a specific Oracle activity over time.
The Activity Reports wizard has four defining windows:
Dimensions - Include in your report template the entire Instance (or Cluster) Level activity or a subset (Specify Activity Filter) of historical (up to three) Dimension data.
Metrics
Select Metrics for Resource: Select here the resource on whose components you want to focus. The chosen metric serves as the initial set of composing metrics to be pane listed time unit in each reporting period. (and as the initial choice for the Display Timeline Graph metric).
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 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.