WRH$_SYSMETRIC_HISTORY_INDEX Index Does Not Get Partitioned After Database Upgrade From 12c To 19c (Doc ID 2777641.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 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

on WRH$_SYSMETRIC_HISTORY

(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:
INDEX_NAME='WRH$_SYSMETRIC_HISTORY_INDEX';
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

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.