ORA-00600 [KWQIDRDQ:LOOP] error reported repeatedly while attempting to Dequeue Messages and other Logical Inconsistency issues

(Doc ID 1070715.6)

Last updated on SEPTEMBER 24, 2013

Applies to:

Oracle Database - Enterprise Edition - Version to [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.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms