My Oracle Support Banner

Row Lock Contention On BALGRP_T During Account Creation Process (Doc ID 2769155.1)

Last updated on FEBRUARY 15, 2024

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.22.0 and later
Information in this document applies to any platform.

Symptoms

Multi Threaded Architecture (MTA) for Custom Account Creation is being developed to create 1:N order such as 1 parent account & N sub-ordinate accounts and being executed for 1:1, 1:100 and 1:5000 scenario. The execution of MTA is taking longer time and in the Database AWR report it is observed that it is taking longer time due to row lock contention.


ACTUAL BEHAVIOR
---------------
Row lock contention on BALGRP_T is observed during Account creation process.


EXPECTED BEHAVIOR
-----------------------
Customer account creation (MTA) should considerably take less time and row lock should be avoided.


Changes

 

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
Changes
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.