Historical Diagnostics Reports

The variety of report types assists DBAs/Managers in understanding their system's behavior. These reports supply supporting documentation of instance activity. The Performance Analysis reports mode is an integral tool in tuning and monitoring Oracle database instances.

Use the supplied predefined read-only templates or create your own reports and save the template definition for subsequent scheduled executions. Output is available in a variety of formats, including window display, html, RTF and pdf file for effortless periodic delivery, distribution and archiving. Accepting the default-specified "Output to Performance Analysis" facilitates archiving and display within Performance Analysis. 

Note: For reports to be run as scheduled, the Windows task schedule systems service must be running and the client must be active and have a network connection.

With the left-pane tree-node focus on a specific report, display its saved editions in a browsing mode in the lower-right pane by clicking on the specific execution reference above.   Report output format is a first page of graphical representation of the data, headings, and definitions; subsequent pages of numeric data points; and a final legend page, if warranted.

To launch the report creation wizard

1. Right click within the:

• Historical tree node

• pane-listed Tops tab

• pane listed Time Breakdown tab
  
   

-OR-

or
 

: '\003cp' CLASS=StepParaTight style=;">Click:

• Actions | Reports in the Toolbar

• Reports in the Performance Analysis navigation bar

2. Select one of the seven available types:

• Executive Workload Summary -  The Executive Workload Summary is a one-click report-generating feature designed to deliver the critical Home Page displayed parameters in a useful configurable format to key decision-makers.

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

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

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

• Trend - The Trend report graphs performance of specified top activities over an entire time period divided into customizable time frames. The purpose of this report is to expose performance changes occurring over extended periods of time.

• Time Breakdown - The Time breakdown report displays the top activities in each customizable time frame within a given period.

• or
   

  : '\003cp' CLASS=StepParaTight style=;">Change Tracking - The Change Tracking report display changes in environments and activity that can potentially influence system performance.

• Compare - The Compare report mechanism displays differences in period activity illustrate underlying performance and monitoring issues.