Re: AWR snapshots empty - ADDM runs fail
- From: De DBA <dedba@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 06 Sep 2013 12:39:43 +1000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
