Performance Issue With REQEXT Batch: AWR Report Shows Enqueue Event "Enq: TX - Row Lock Contention"
Last updated on FEBRUARY 20, 2018
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
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:
- Execute REQEXT batch with multiple threads.
- RPL_NET_INVENTORY_TMP table will be partitioned on items for those threads above.
- The REQEXT batch tries to act upon same transfer records to update TSFDETAIL.TAX_AMOUNT, leading to longer processing times.
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