My Oracle Support Banner

Row Lock Contention When D1-IMD Batch Is Executed With Large Number Of Threads (Doc ID 2487488.1)

Last updated on AUGUST 05, 2020

Applies to:

Oracle Utilities Meter Data Management - Version 2.2.0.1.0 and later
Oracle Utilities Framework - Version 4.3.0.4.0 to 4.3.0.4.0 [Release 4.3]
Information in this document applies to any platform.

Symptoms


When a batch thread ends, it locks the batch control table to update the status. A job running with a large amount of threads will experience row lock contention because all threads will do the locking to update the status.


Steps -
The issue can be reproduced at will with the following steps:
1. Create device set up.
2. Create IMD for MC.
3. Execute D1-IMD batch involving large number of threads.



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.