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've been working as an Oracle database administrator and PeopleSoft administrator since 1994. I'm very interested in Oracle performance tuning.
This entry was posted in Uncategorized. Bookmark the permalink.

3 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. kevinclosson says:

    Whoa, ok. Thanks.

Leave a Reply