Recently I discovered the RAC version of the AWR report – awrgrpt.sql. Today was the first time I used it for a real system. In this case a 12 node Exadata system. awrgrpt.sql is in $ORACLE_HOME/rdbms/admin just like the normal AWR report – awrrpt.sql.
In this case we had a complaint about the system performance for a particular hour but the OS Statistics showed an almost idle system. Here is the output: OS Statistics.
This was really helpful because in the past I had been running awrrpt.sql on all 12 nodes. I made a script to do it, but still it ran for a long time and 12 AWR reports were hard to handle.
awrgrpt.sql produced a nice summary of the activity of all 12 nodes and in this particular case the OS Statistics part of the report clearly shows an almost idle system in terms of CPU.