ORA-00600 [KWQIDRDQ:LOOP] error reported repeatedly while attempting to Dequeue Messages and other Logical Inconsistency issues
(Doc ID 1070715.6)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 8.1.7 to 11.1]
Information in this document applies to any platform.
A variety of symptoms may be reported including
ORA-00600: [kwqidrdq: loop] reported on dequeue of a message from an Advanced Queueing (AQ) Multi-Consumer Queue Table.
The following functions appear in the stack trace.
A Queue Monitor (QMON) slave (q00*) consuming a large amount of CPU and this being associated with work on a single queue table.
A message stuck in READY state but not being able to dequeue it or propagate it.
A message stuck in WAITING state but not being changed to the READY state after the appropriate time interval.
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