How To Generate AWR Report in Oracle Database?

by

To generate AWR report, ASH report, and ADDM report for Oracle RAC and non-RAC databases.

Below are the sql scripts to execute as a Sysdba user to generate AWR, ADDM, and ASH reports on Oracle RAC and non-RAC databases:

Mandatory to generate AWR, ADDM, and ASH reports on Oracle RAC and non-RAC databases.

SQL script to generate AWR report for a single instance database:

SQL>@$ORACLE_HOME/rdbms/admin/awrrpt.sql

SQL script to generate AWR Report on RAC database:

SQL>@$ORACLE_HOME/rdbms/admin/awrgrpt.sql

SQL script to generate ADDM Report for a single instance database:

SQL>@$ORACLE_HOME/rdbms/admin/addmrpt.sql

SQL script to generate ADDM Report on RAC database:

SQL>@$ORACLE_HOME/rdbms/admin/addmrpti.sql

SQL script to generate ASH report for a single instance database:

SQL>@$ORACLE_HOME/rdbms/admin/ashrpt.sql

SQL script to generate ASH Report on RAC database:

SQL>@$ORACLE_HOME/rdbms/admin/ashrpti.sql

The mandatory AWR report, ASH report, and ADDM report for Oracle RAC and non-RAC databases are above. You can choose any report to generate on Oracle RAC and non-RAC databases.

Leave a Comment