DDL on Table/Index WIth Many Subpartitions Takes Longer After Migrating To 11g

(Doc ID 1285491.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Server - 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms