Missing Index on CI_SEV_PROC table (CCB 2.3.1)

Posted by ACShorten on Oracle Blogs See other posts from Oracle Blogs or by ACShorten
Published on Sun, 25 Mar 2012 20:08:43 -0500 Indexed on 2012/03/26 11:39 UTC
Read the original article Hit count: 365

Filed under:

One of our customers reported performance issues with the severence processes in Oracle Utilities Customer Care And Billing V2.3.1 and after investigation a base index was found to be missing in the base package installation scripts. This index can be created manually to address any performance issues in this part of the system.

For details of the index creation, refer to the KB Article on My Oracle Support KB 1431632.1 Index Missing On CI_SEV_PROC Table.

© Oracle Blogs or respective owner

Related posts about /Oracle/Advice