DDL on Table/Index WIth Many Subpartitions Takes Longer After Migrating To 11g
(Doc ID 1285491.1)
Last updated on FEBRUARY 28, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Rebuilding index subpartitions takes significantly longer under 11g than 10g. Prior to the upgrade, approximately 800 subpartition indexes could be rebuilt per hour at the customer's site. After the upgrade to 11g, that number dropped to about 40-50 per hour.
Applying the 220.127.116.11 patch set (which includes the fix for <Bug 9666605> - Bug 9666605: KGHALF() - FREEABLE MEMORY ALLOCATION TAKES MORE TIME ON 64-BIT MACHINE) sped the process from 40+ indexes per hour to 500+ indexes per hour, but was still well short of the number that could be built under 10gR2.
Migration from 10gR2 to 11gR2.
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