Trend Report

Performance Analysis for Oracle

Trend

The Trend report displays top aggregated dimension and metric resource usage over time.

The Trend 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 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. 

  • 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 which 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.

  1. 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.

  2. 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

    • your graph style, representing the time period graphs as either stacked or side-by-side entries

    • 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.