Friday, March 31, 2017

Generating AWR Reports

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 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



No comments:

Post a Comment