SAP-Oracle AWR Reporting

Oracle AWR report might be required to generate for SAP managed oracle databases (based on customer or technical requirement).

To perform the reporting, please follow the below steps.

Read the following SAP Notes:-

Note 1457893 - How to generate Oracle ADDM, ASH and AWR reports

Note 1326067 - Configure retention period for Automatic Workload Repository

1) check the AWR snap interval & Retention time – use following query:

Sql>SELECT * FROM DBA_HIST_WR_CONTROL

2) Oracle provides two scripts to produce workload repository reports (awrrpt.sql and awrrpti.sql).

Sql>@$ORACLE_HOME/rdbms/admin/awrrpt.sql

Sql>@$ORACLE_HOME/rdbms/admin/awrrpti.sql

Note: awrrpt.sql & awrrpti.sql are exactly same except that awrrpti report allows specific instance to report on. awrrpti.sql asks to enter dbid for particular instance of interest.

 The default settings (snapshot & Retention) for AWR report can be changed according to the requirement using SAP Note 1326067.

 

For more information on AWR Reporting, Please check the following link

http://adfoc.us/1746541