My Oracle Support Banner

Create Index During SP3 Upgrade Takes Too Long (Doc ID 2317962.1)

Last updated on MARCH 15, 2019

Applies to:

Oracle Utilities Meter Data Management - Version and later
Information in this document applies to any platform.


We are trying to apply Service Pack 3 on MDM environment.
During upgrade, Index(D1T304S2) is created from D1_INIT_MSRMT_DATA, but because there are already huge amount of records (about 12TB with partitioned) in D1_INIT_MSRMT_DATA, we are expecting that it will take a long time (maybe more than 20 hours) for "Create Index".
In our development environment, it took about 30 minutes with 527GB in D1_INIT_MSRMT_DATA.

Is there any way to shorten the execution time as mush as possible?


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

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