Applications Hanging when Performing Database Operations on the SMS (Doc ID 2191221.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Communications Network Charging and Control - Version 4.3.0 to 6.0.0 [Release 4.3 to 6.0]
Information in this document applies to any platform.

Symptoms

On all versions of Oracle Communications Network Charging and Control (OCNCC or NCC) and Oracle Communications Convergent Charging Controller (OC3C), an Oracle Database Management System (DBMS) job installed with the NCC/OC3C software can lock objects for an excessive duration resulting in unresponsive applications which are blocking waiting to access the locked object.

The DBMS job in question is the SMS_DEFRAG_REP_IOT job which is scheduled to run every 10s.

This job will check the REP_ORA_RENUMBERED and REP_ORA_EVENT Index Organized Tables (IOTs) and rebuild them if they are fragmented.  This is to ensure the speed of replication remains consistently fast over time.

If this job fails to rebuild the IOTs for a long period of time (likely due to being unable to obtain a lock on the table), then the IOTs will become further fragmented.  When the job does manage to get a lock on the table, it will spend significantly longer to rebuild the IOTs and lock them for longer, potentially affecting applications.

Changes

None.

Cause

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