Create Index During SP3 Upgrade Takes Too Long

(Doc ID 2317962.1)

Last updated on DECEMBER 14, 2017

Applies to:

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

Goal

We are trying to apply Service Pack 3 on MDM 2.1.0.2 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?
 

Solution

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