My Oracle Support Banner

Upgrade From 12.2 To 19c Is Taking A Long Time (Doc ID 2806422.1)

Last updated on APRIL 17, 2023

Applies to:

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


You are  using autoupgrade tool with upgrade option on new cluster. The 17TB database took almost 11 hours.

You want to minimize the upgrade time as much as possible.

As per the analysis it is mainly taking time to perform the bug 28145995 incorporated changes





SQL> Rem =======================================================================

SQL> Rem END per PDB Capture changes

SQL> Rem =======================================================================


SQL> Rem ***********************************************************************

SQL> Rem Begin bug 28145995 : update indpart$ for local index on ref part tables

SQL> Rem **********************************************************************


SQL> update indpart$ ip set part# = (select tpv.phypart# from ind$ i, tabpartv$ tpv, indpartv$ ipv where ip.obj# = ipv.obj# and = i.obj#

and = and ipv.part# = tpv.part#) where bo# in

(select ipo.obj# from partobj$ ipo, ind$ i, partobj$ tpo where bitand(ipo.flags, 1) != 0 -- index is local and ipo.obj# = i.obj# and = tpo.obj#  and tpo.parttype = 5 -- table is ref partitioned );

This bug caused by the fix for the bug 28145995


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.