awrgrpt.sql AWR report for RAC and Exadata

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

About Bobby

I live in Chandler, Arizona with my wife and three daughters. I work for US Foods, the second largest food distribution company in the United States. I have worked in the Information Technology field since 1989. I have a passion for Oracle database performance tuning because I enjoy challenging technical problems that require an understanding of computer science. I enjoy communicating with people about my work.
This entry was posted in Uncategorized. Bookmark the permalink.

7 Responses to awrgrpt.sql AWR report for RAC and Exadata

  1. kevinclosson says:

    Hi Bobby,

    12 nodes? That’s an odd number of hosts. Is this a 1+1/4 rack config?

    • Bobby says:

      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

  2. darcio says:

    Thanks a lot

  3. 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/

    • Bobby says:

      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

Leave a Reply to Bobby Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.