Long Execution Time for Creating I_EVENT_SESSION_OBJ__ID Index
(Doc ID 2911717.1)
Last updated on APRIL 08, 2024
Applies to:
Oracle Communications Billing and Revenue Management - Version 12.0.0.7.0 and laterInformation in this document applies to any platform.
Goal
During installation of Billing and Revenue Manager (BRM) 12.0 PatchSet 7 on pre-production environment, it was observed a problem on create index step (new indexes) (create_indexes_upgrade.source script).
It is mainly about this index : I_EVENT_SESSION_OBJ__ID ON EVENT_T.
Table EVENT_T is most largest table on production environment and create this index takes about 10-12 hours to finish.
That will cause a huge problem with planning implementation window on production.
Questions:
1. How important is this index and whether it is used by any of the streams like API?
2. The definition of this index can be modified with ONLINE clause?
3. Can customer add This index after the implementation window?
Solution
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
Goal |
Solution |