My Oracle Support Banner

Recommendation for Slow DB Upgrade to 12.2.0.1 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 12.2.0.1 and later
Information in this document applies to any platform.

Goal

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

 



Solution

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
Goal
Solution
References


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