Cluster Wide ASH Report

Posted in: Technical Track

Well it was unknown to me until yesterday and possibly this is new thing for no one but me, but lets blog it anyway :)

One of the most nice thing about the newer versions of Oracle is the advent of ASH and AWR as they provide awesome diagnostic information. Many customers at the Pythian use Real Application Cluster and having a cluster wide AWR report by using awrgrpt.sql script is very handy.

But often we need to zero-in to certain spikes and blips which occur within very short span of time and due to the interval of AWR report it becomes nearly impossible to go back in history and pinpoint the issue to that very minute time slot using AWR report.

Cluster wide ASH report comes to the rescue. The script ashrpti.sql lets you specify ALL or instances by number like 1,2,3,4 during its run to get the cluster wide report. You can specify the time duration and many other things like SQL_ID to pull out the specific report you want.

Both awrgrpt.sql and ashrpti.sql reside in $ORACLE_HOME/rdbms/admin directory.

Interested in working with Fahd? Schedule a tech call.

About the Author

I am in love with Oracle blogging since 2007. The blogging coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies enabled me to get Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth, I have been expressing my love for Exadata. These days for the last some years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

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