Throughput Report

Performance Analysis for Oracle

Throughput

The Throughput report shows the throughput of a specific resource as a result of the load placed upon the resource by a given Oracle entity. The most common Template defaults: Upper is response time and lower is load (example CPU usage compared with SQL executions) so that variable functions can be compared one to another.

The Throughput Reports wizard has four defining windows:

  1. Dimensions - Include in your report template the entire Instance Level activity or a subset (Specify Activity Filter) of historical (up to three) Dimension data.

  2. Metrics

  3. 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 Upper Graph Metric).   

  4. Select from among the potential metric subset the Lower Graph Metric.

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

  3. Create a textual:

  4. Report Description - An optional user-input for referencing and clarification. Useful when saving the report template.

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

  6. File name - Name of the report file template. A recommended default is suggested.

  7. Click Save to save the template for subsequent executions.

  8. Use Schedule to set the periodic Schedule and Delivery Optionsfor this report's execution and archiving.

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

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

  •