Index WRH$_SYSMETRIC_HISTORY_INDEX Status Unusable
(Doc ID 2426391.1)
Last updated on SEPTEMBER 14, 2023
Applies to:
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Following index becomes UNUSABLE:
WRH$_SYSMETRIC_HISTORY_INDEX
-
Many errors in MMON workers like :
*** KEWROCISTMTEXEC - encountered error: (ORA-00942: table or view does not exist
*** SQLSTR: total-len=354, dump-len=354,
STR={delete from WRH$_SYSMETRIC_HISTORY_BL tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id)) }
Changes
The following patch was applied:
Bug 19651064 PURGING RECORDS FROM WRH$_ACTIVE_SESSION_HISTORY AND WRH$_SQL_PLAN HAVE BEEN UNS
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |