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 126.96.36.199 and later
Information in this document applies to any platform.
We are trying to apply Service Pack 3 on MDM 188.8.131.52 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