Oracle Performance | How to Read oracle AWR Report | AWR Report1
Oracle Performance.
How to Read oracle AWR Report?
What are the different sections of AWR Report?
Different kinds of reports can be generated from that location such as.
SQL script for getting AWR Report for single instance:
SQL @$ORACLE_HOME/rdbms/admin/awrrpt.sql
SQL script for getting AWR Report on RAC database:
SQL- @$ORACLE_HOME/rdbms/admin/awrgrpt.sql
SQL script for getting ASH Report for single Instance:
SQL- @$ORACLE_HOME/rdbms/admin/ashrpt.sql
SQL- script for getting ASH Report on RAC database:
SQL- @$ORACLE_HOME/rdbms/admin/ashrpti.sql
SQL script for getting ADDM Report on RAC database:
SQL- @$ORACLE_HOME/rdbms/admin/addmrpti.sql
SQL script for getting ADDM Report for single instance:
SQL- @$ORACLE_HOME/rdbms/admin/addmrpt.sql
SQL script for getting SQL report on RAC database:
SQL- @$ORACLE_HOME/rdbms/admin/awrsqrpi.sql;
SQL script for getting SQL report for single instance:
SQL- @$ORACLE_HOME/rdbms/admin/awrsqrp.sql;