I have been asked to write a shell script that will automatically generate an AWR report from current last snapshot -1 to the current snapshot. Then emailed automatically the resulting report to the db team list;
These are the little 2 scripts I have written and tested on 7 nodes RAC 11gR2 database. In the case of RAC database, you copy the scripts across the nodes and modify the instance number ID from the first script. You can also use them for a single instance database.
read the complete post here: www.oracle-class.com