Obrm Performance Is Very Slow Due To Enq: Tx - Row Lock Contention (Doc ID 1366580.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 12-Apr-2013.

Symptoms

Query below executed from OBRM is very slow due to enq: TX - row lock contention.

select poid_DB, poid_ID0, poid_TYPE, poid_REV, created_t, mod_t, read_access, write_access, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, batch_cntr, billinfo_obj_DB, billinfo_obj_ID0, billinfo_obj_TYPE, billinfo_obj_REV, effective_t, name, object_cache_type, realtime_cntr
from bal_grp_t
where poid_id0 = :1 for
update of bal_grp_t.poid_id0

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