Oracle write consistency bug and multi-thread de-queuing

Submitted by fpachot on Thu, 09/27/2018 - 16:48
Blog article:

Interesting.

Just playing with a couple of options that you'd be well aware of anyway - add STATUS or NAME into the nested selects.

Or partition the table by status with row movement enabled which might have been a worthwhile consideration for such a table anyway?

Submitted by Anonymous (not verified) on Mon, 12/03/2018 - 07:41

Permalink

Hi, You can track ORA_ROWSCN at row level and do 2nd updates if ORA_ROWSCN not changed . Thanks.

Disclaimer

The views expressed in this blog are those of the authors and cannot be regarded as representing CERN’s official position.

CERN Social Media Guidelines

 

Blogroll