View Dba_hist_sysmetric_summary Is Not Getting Populated After Db Upgrade From 12.2.0.1 To 19.7
(Doc ID 2738053.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.7.0.0.0 and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- View dba_hist_sysmetric_summary is not getting populated after db upgrade from 12.2.0.1 to 19.7
- From the MMON Trace:
*********** START A RUN OF [Auto-Flush Slave Action] *************
*** 2020-12-16 01:00:40.813
*** KEUUXS - encountered error: (ORA-01502: index 'SYS.WRH$_SYSMETRIC_HISTORY_INDEX' or partition of such index is in unusable state <<<<<
)
*** SQLSTR: total-len=328, dump-len=328,
SQLSTR={insert into wrh$_sysmetric_history (dbid, per_pdb, con_dbid, snap_id, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :dbid, 0 per_pdb,
:srcdbid con_dbid, :snap_id, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value FROM x$kewmdrmv drmv WHERE (1 = 1) }
*** kewrftecpc-3: Error=-36352 encountered by kewrftecpc
Changes
Database Upgrade to 19.7.
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 |
References |