Create Index During SP3 Upgrade Takes Too Long
Last updated on DECEMBER 14, 2017
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?
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