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 MARCH 04, 2024

Applies to:

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


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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.