My Oracle Support Banner

Performance Issue With REQEXT Batch: AWR Report Shows Enqueue Event "Enq: TX - Row Lock Contention" (Doc ID 1266828.1)

Last updated on AUGUST 16, 2022

Applies to:

Oracle Retail Merchandising System - Version 12.0.5 and later
Information in this document applies to any platform.
 

Symptoms

Users are experiencing a performance issue with a multi-threaded  REQEXT batch.  Analysis of the Automatic Workload Repository (AWR) report shows the enqueue event "TX - Row Lock Contention" on the batch process; as a result, the batch must run for a longer time when the same transfer records are being worked on by multiple items. 

Steps to Recreate:

  1. Execute REQEXT batch with multiple threads.
  2. RPL_NET_INVENTORY_TMP table will be partitioned on items for those threads above.
  3. The REQEXT batch tries to act upon same transfer records to update TSFDETAIL.TAX_AMOUNT, leading to longer processing times.

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.