My Oracle Support Banner

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 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

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 11.2.0.2 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.

Changes

Migration from 10gR2 to 11gR2.

Cause

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
Symptoms
Changes
Cause
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.