High Row Lock Contention On The ORMB Batch Control Table (Doc ID 2296657.1)

Last updated on AUGUST 18, 2017

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.5.0.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.5.0.3.0 version, BT - Batch

ACTUAL BEHAVIOR
---------------
ORMB 2.5.0.3 : High Row Lock Contention On The ORMB Batch Control Table

User have a row lock contention for below update query in C1-TXNRB(Roll Back Batches), using Clustered environment ORMB2.5.0.3 version.

Thread Count used for Roll back batch- 6

UPDATE CI_BATCH_CTRL SET LAST_UPDATE_DTTM = :1 WHERE BATCH_CD = :2 /* com.splwg.base.support.batch.BatchRunOrchestrationHelper */.


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