Generating AWR Reports

You can generate AWR reports by running SQL scripts, as described below :-

# Generating an AWR Report

@$ORACLE_HOME/rdbms/admin/awrrpt.sql

# To generate an AWR report on a specific database instance:

@$ORACLE_HOME/rdbms/admin/awrrpti.sql

# To generate an AWR report in an Oracle RAC environment: 

@$ORACLE_HOME/rdbms/admin/awrgrpt.sql

#To generate an AWR report on a specific database instance in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgrpti.sql

# To generate an AWR report for a particular SQL statement:

@$ORACLE_HOME/rdbms/admin/awrsqrpt.sql

# To generate an AWR report for a particular SQL statement on a specified database instance:

@$ORACLE_HOME/rdbms/admin/awrsqrpi.sql

#To generate an AWR Compare Periods report:

@$ORACLE_HOME/rdbms/admin/awrddrpt.sql

# To generate an AWR Compare Periods report in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgdrpt.sql

# To generate an AWR Compare Periods report on a specified database instance:

@$ORACLE_HOME/rdbms/admin/awrddrpi.sql

# To generate an AWR Compare Periods report on a specified database instance in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgdrpi.sql

# To generate an ASH report:

@$ORACLE_HOME/rdbms/admin/ashrpt.sql

# To generate an ASH report on a specified database instance:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql

# To generate an ASH report in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql