Viewing Oracle AWR reports

If you are using Oracle Database, you can view an Automatic Workload Repository (AWR) report for the two most recent snapshots of the Oracle database in the IBM TRIRIGA Administrator Console. The AWR report is displayed in the Database Manager object of the Administrator Console in a section labeled Latest Oracle AWR Report.

Before you begin

To view the AWR report in the TRIRIGA Administrator Console, you must have sysdba access to the database schema.

Procedure

  1. Select Database Manager in the Administrator Console..
  2. If you see a message such as The database name schema can not select from one or more of the following Oracle sys tables, follow the instructions on the screen for running the grant commands. The commands provide the permissions to the schema so that the Oracle AWR report is displayed directly in the TRIRIGA Administrator Console.

Results

The AWR report is displayed after the Database Admin Tasks and Database Space sections in a section labeled Latest Oracle AWR Report. The report might take a short time to generate and display.

What to do next

The AWR report is included in the error report file bundle with other troubleshooting data that is created when you select Must Gather Tool in the Administrator Console.