My Oracle Support Banner

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 later
Information 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


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