AWR Report Generation

Generating Automatic Workload Repository Reports

An AWR report shows data captured between two snapshots (or two points in time). The AWR reports are divided into multiple sections. The HTML report includes links that can be used to navigate quickly between sections. The content of the report contains the workload profile of the system for the selected range of snapshots. The primary interface for generating AWR reports is Oracle Enterprise Manager. Whenever possible, you should generate AWR reports using Oracle Enterprise Manager,  If Oracle Enterprise Manager is unavailable, you can generate AWR reports by running SQL scripts, as described in the following sections:

The awrrpt.sql SQL script generates an HTML or text report that displays statistics for a range of snapshot IDs.

At the SQL prompt, enter:

@$ORACLE_HOME/rdbms/admin/awrrpt.sql

Specify whether you want an HTML or a text report:

Enter value for report_type: text

In this example, a text report is chosen.

Specify the number of days for which you want to list snapshot IDs.

Enter value for num_days: 2

* A list of existing snapshots for the specified time range is displayed. In this example, snapshots captured in the last 2 days are displayed

Specify a beginning and ending snapshot ID for the workload repository report:

Enter value for begin_snap: 150

Enter value for end_snap: 160

* In this example, the snapshot with a snapshot ID of 150 is selected as the beginning snapshot, and the snapshot with a snapshot ID of 160 is selected as the ending snapshot.

Enter a report name, or accept the default report name:

Enter value for report_name:

Using the report name awrrpt_1_150_160

In this example, the default name is accepted and an AWR report named awrrpt_1_150_160 is generated.


Note* : you can specify a specific location by providing the complete file structure and the file name or provide the file name alone to get this generated at the default location : The default location for the awrreport is ?/rdbms/admin/