Poor PI CCSCD1=DEL Performance (Doc ID 2112069.1)

Last updated on MARCH 07, 2016

Applies to:

Oracle Communications Network Charging and Control - Version 4.3.0 and later
Information in this document applies to any platform.

Symptoms

In all versions of Oracle Communications Network Charging and Control (NCC), when using the Provisioning Interface (PI) to delete provisioned subscribers using the PI CCSCD1=DEL command, high latency is observed resulting in poor throughput and overall performance.

Although not immediately obvious without an Oracle Database Automatic Workload Repository, the underlying database updates are stuck due to "enq: TM – contention".

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