Please visit for Videos, Free posts, Books, Webinar and Free forum … ALL about Oracle!

May 21, 2011

11gR2 RAC – run ADDM report

Filed under: Uncategorized — orawiss @ 3:38 pm

From 11g, ADDM report is including RAC cluster analysis as a part of the overall ADDM database analysis process.
You can use the package DBMS_ADDM to run, analyze and get ADDM reports.
You can call the procedure analyze_db of the DBMS_ADDM package to analyze the RAC database, or you can use the procedure analyze_inst procedure to analyze a specific instance within the RAC. The procedure analyze_partial of the DBMS_ADDM package can be used to analyze a set of instances.

How to get an ADDM report of the overall database?
First, we will get the list of valid snapshots from the wrm$_snapshot view;
Read the complete article here: THE ARTICLE


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: