Re: AWR snapshots empty - ADDM runs fail

From: David Fitzjarrell <>
Date: Thu, 5 Sep 2013 06:43:57 -0700 (PDT)
Message-ID: <>

What do you get when you run a manual snapshot?

David Fitzjarrell  

 From: De DBA <>
Sent: Thursday, September 5, 2013 5:49 AM Subject: Re: AWR snapshots empty - ADDM runs fail   

I should have been more specific. When I said "enabled management pack access for the Diagnostic & Tuning packs" , I meant to state that control_management_pack_access = 'DIAGNOSTIC+TUNING'; This exact same problem occurs in all 6 configured databases. The databases are installed in 2 separate LPARs, 3 in each. Perhaps MMON on AIX has a known bug that may cause this?


Update: today configured 2 production instances as described earlier and noted that all existing AWR snapshots in these instances (8 days worth) are also empty. These are busy OLTP instances, located in a third LPAR. Sadly, there are no AWR snapshot or MMON problems logged in any of the 8 instances (alert logs go back to March 2012).


On 05/09/13 00:13, Job Miller wrote:
> is control_management_pack_access in init.ora set by any chance?
> Job


> *From:* Martin Klier <>
> *To:*
> *Cc:*
> *Sent:* Wednesday, September 4, 2013 8:40 AM
> *Subject:* Re: AWR snapshots empty - ADDM runs fail
> Hi,
> recently had a stuck MMON on 11gR2 that caused having no snapshots at
> all. My lesson learned: Check alert log at corresponding time.
> Don't know if it's helpful, but MMON should be a good starting point for
> investigation for AWR issues.
> Regards
> Martin
> De DBA schrieb:
<snip due to overquoting> -- --
Received on Thu Sep 05 2013 - 15:43:57 CEST

Original text of this message