Re: AWR snapshots empty - ADDM runs fail

From: De DBA <dedba_at_tpg.com.au>
Date: Fri, 06 Sep 2013 12:39:43 +1000
Message-ID: <5229406F.8010707_at_tpg.com.au>

Curiouser and curiouser. I've been able to narrow the problem down to the WRH$%NAME lookup tables: they are empty, apart from WRH$_METRIC_NAME. The actual statistics are being collected normally. Since the relevant DBA_HIST% views join these against the WRH$%NAME tables, it looks as if the snapshots are empty!

To make matters even more amazing, in 2 databases, the lookup tables have been populated overnight... Now the question is: which process is responsible for (re-)populating the lookup tables? Clearly a normal snapshot does not do it. I did some googling to see if it is safe to manually populate them (don't see why not, but one never knows), but found nothing. What do you think?

The lookup tables are:

   1* select table_name from dba_tables t where table_name like 'WRH$%' and not exists ( select 'x' from dba_tab_columns c where c.column_name = 'SNAP_ID' and c.table_name = t.table_name ) SQL> / TABLE_NAME

---

WRH$_IOSTAT_FUNCTION_NAME
WRH$_IOSTAT_FILETYPE_NAME
WRH$_EVENT_NAME
WRH$_LATCH_NAME
WRH$_STAT_NAME
WRH$_OSSTAT_NAME
WRH$_PARAMETER_NAME
WRH$_METRIC_NAME

Cheers,
Tony

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 06 2013 - 04:39:43 CEST