Monday, 29 July 2013

Script to generate multiple AWR report in RAC - Oracle

Script to generate multiple AWR report in RAC – Oracle

Follow the below steps to generate the report

1.       Source the profile
2.       Set the SID
3.       Copy and paste the below link in browser.
4.       Click download
5.       Copy the gen_awr.sh file to the server
6.       Execute the script using following command and follow the instruction.
$sh gen_awr.sh