WRH$_SYSMETRIC_HISTORY_INDEX Index Does Not Get Partitioned After Database Upgrade From 12c To 19c
(Doc ID 2777641.1)
Last updated on MAY 28, 2021
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
- Database upgraded from 12c to 19.7 using DBUA
- After the Database upgrade the index "WRH$_SYSMETRIC_HISTORY_INDEX" went to UNUSABLE status and non-partitioned
- Verified post install script which calls the catawrtb.sql that comes with patch 19651064 as per <Document 2426391.1>:
$ grep -A4 -i SYSMETRIC_HISTORY_INDEX catawrtb.sql
create index WRH$_SYSMETRIC_HISTORY_INDEX
(dbid, snap_id, instance_number, group_id, metric_id, begin_time, con_dbid)
local tablespace SYSAUX
- Though script showing as partitioned with keyword "local", but, the index remains non-partitioned:
no rows selected
Database upgrade from 12c to 19c
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