How to run an AWR report

• Product: Aleph
• Product Version: 20, 21, 22, 23
• Relevant for Installation Type: Dedicated-Direct, Direct, Local

Question    
How can an Oracle AWR report be run (for the purpose of analyzing Oracle behavior within a certain timeframe)? This can be useful when there is an indication that the Oracle process(es) may be the cause of overall product performance issues. These reports can be sent to DBAs for analysis.

Answer    
Sign on to the server: 

1- grep ora /etc/passw (to find the relevant Oracle Unix user) 
2- sudo su - oracle* (*- the suffix of the relevant Unix Oracle user . From a user with sudo rights: ) 
3- cd $ORACLE_HOME/rdbms/admin 
4- sqlplus '/as sysdba' 
5- set pause off 
6- @awrrpt 
7- You will then be prompted for the type of report (html or text) 
8- You will then be prompted for the number of days back, in which you will see a list of relevant hours for generating the report. Choose the number of days back, and you will see a list of hours from the number of days back until the present time. Each hour has a unique identifier number in the left. Enter the identifier of the relevant hour from which you would like the report to start. 
9- Enter the identifier number of the hour that you would like the report to complete (Keep in mind that these reports are very verbose) 
10 - you will be prompted to Enter value for report_name (file name) 
11- Once the report is complete, you will be able to find the report file under $ORACLE_HOME/rdbms/admin/

• Article last edited: 6-Jun-2016