My Oracle Support Banner

Recommendation for Slow DB Upgrade to when it Partitions WRI$_OPTSTAT_SYNOPSIS% ,WRI$_OPTSTAT_SYNOPSIS_HEAD$ (Doc ID 2560849.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


While upgrade database   to 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

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