[ Oracle DB Performance Tuning ] - Scripts to generate AWR report in Command line

@$ORACLE_HOME/rdbms/admin/awrrpt.sql
 - Generate AWR report for Standalone Database.

 

@$ORACLE_HOME/rdbms/admin/awrrpti.sql
 - Generate AWR report for a specific instance in a Standalone or RAC database.

 

@$ORACLE_HOME/rdbms/admin/awrgrpt.sql
 - Generate AWR report for all instances of the RAC database.

 

@$ORACLE_HOME/rdbms/admin/awrgrpti.sql
 - Generate AWR report for a specific instance in a RAC database.

 

@$ORACLE_HOME/rdbms/admin/awrsqrpt.sql
 - Generate AWR report for a specific SQL ID for your database.

 

@$ORACLE_HOME/rdbms/admin/awrsqrpi.sql
 - Generate AWR report for a specific SQL ID for a specific DB instance in your RAC DB. 

Watch Video Format: https://www.youtube.com/shorts/3s0SJh4s5_I