My Oracle Support Banner

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

Last updated on AUGUST 02, 2020

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

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
Symptoms
Cause
Solution
References


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