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.
– Bobby
Hi Bobby,
12 nodes? That’s an odd number of hosts. Is this a 1+1/4 rack config?
Kevin,
We have two full V2 racks connected together with Infiniband. Our production cluster has 12 hosts, 8 on one rack and 4 on the other. We have two 2 node clusters for development and test.
– Bobby
Whoa, ok. Thanks.
Thanks a lot
You are welcome.
12 nodes, I hate to imagine how long it took to do PSU/CPU patching. I am already upset having to patch a 3-node cluster. And with Exadata, Oracle Platinum took 24 hours to finish the patching. Would be nice to have an AWR generator for running awrgrpt though in a non-interactive way similar to https://flashdba.com/database/useful-scripts/awr-generator/
Yes. It was hard to manage a 12 node Exadata V2 cluster. We replaced it with a 2 node Exadata X5 and it runs like a dream by comparison.
That AWR Generator script looks pretty neat. My script was simplistic by comparison I am sure.
Thank you for your comment.
Bobby