Monday, May 23, 2011

awrgrpt.sql in Exadata

Oracle RAC is just a part of Oracle Exadata, and if you need to have AWR reports generated from all the instances, which is often the case if you are working Oracle support, then you can use the awrgrpt.sql script. You just have to supply the starting/ending snap ids and the location, and just from one db node you can get the AWR report from all the instances. You can also get report from just one instance by using awrgrpti.sql script.

This newer awrgrpt.sql script has replaced the older server performance script the spawrrac.sql.

No comments: