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

Last updated on APRIL 17, 2023

Applies to:

Goal

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>

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

SQL> Rem END per PDB Capture changes

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

SQL>

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

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

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

SQL>

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

and i.bo# = tpv.bo# 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 i.bo# = tpo.obj#  and tpo.parttype = 5 -- table is ref partitioned );

This bug caused by the fix for the bug 28145995

Solution

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