Recommendation for Slow DB Upgrade to 22.214.171.124 when it Partitions WRI$_OPTSTAT_SYNOPSIS% ,WRI$_OPTSTAT_SYNOPSIS_HEAD$
(Doc ID 2560849.1)
Last updated on JULY 22, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
While upgrade database to 188.8.131.52 using DBUA or manual upgrade is taking long to complete and need recommendations on all possible ways to reduce the upgrade time.
It was observed in few test upgrades the maximum time (around 3 hrs or more ) is being taken around large tables wri$_optstat_synopsis$ and wri$_optstat_synopsis_head$.
Details collected from oracle_server.log
Line 546421: PHASE_TIME___START 50 18-08-24 07:15:52
Line 554602: PHASE_TIME___END 50 18-08-24 10:06:11
If the database is configured with PARTITIONED tables with INCREMENTAL STATS, then WRI$_OPTSTAT_SYNOPSIS_HEAD$ and WRI$_OPTSTAT_SYNOPSIS$ will be populated when gather stats is being run.
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