Workload Reporting

This sub-monitor in the SAP/Oracle Database Monitor lets you display very detailed reports from Oracle’s Active Workload Repository.

You choose Performance Wait Event Analysis Workload Reporting in the DBA Cockpit.

Choose one of the following to get the report you require:

AWR report (text)
Workload report with text output
AWR report (web)
Workload report with web page display
AWR DIFF report (text)

Workload compare period report (difference report) with text output
AWR DIFF report (web)

Workload Compare period report (difference report) with web page display
SQL report (text)
Workload SQL report with text output
SQL report (web)
Workload SQL report with web page display
ASH report (text)
Active session history report with text output
ASH report (web)
Active session history report with web page display
ADDM report (text)
Automatic database diagnostic monitor (ADDM), only available as text output

Note Note

For more information about the reports, see the Oracle documentation about the Active Workload Repository.

End of the note.

You need to enter the following parameters for the report:

Begin Snapshot and End Snapshot for all reports
Begin Snapsh. 2 and End Snapshat 2 for compare period reports only
SQL ID for SQL reports
AvgBlReadT, “average block read time”, in milliseconds for the ADDM report.

This is the average time to read a single database block. This value is used in the ADDM report for parameter DBIO_EXPECTED.

For more information about this parameter, see the Oracle documentation. Oracle uses a default value of 10 milliseconds. The current monitor proposes gv$system_event-time_waited_mico / gv_system_event-total_waits for event db_file_sequential_read.

The monitor displays reports according to the format you selected:

Text
The display uses an editor with search and download functions.
Web
The HTML display uses a browser area with navigation functions and right-click functions similar to a normal web browser.