My Oracle Support Banner

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

Last updated on MARCH 22, 2022

Applies to:

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

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

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.