ORA-00060 Deadlock When Purging Exception Queue
(Doc ID 2740150.1)
Last updated on MAY 11, 2022
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
Unexpected deadlock when purging exception queue
Normal queue and Exception queue resides in two different queue tables
- Enqueue 100k messages in Normal queue with message expiration = 1 second
- Commit the enqueue transaction and then sleep for 10 seconds
- Run purge_queue_table to purge the Exception queue table
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