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

Last updated on MAY 30, 2017

Applies to:

Oracle Retail Merchandising System - Version 12.0.5 and later
Information in this document applies to any platform.
Checked for relevance as on 25-JUL-14

Symptoms

We 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

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