3 Replies Latest reply: Feb 6, 2014 4:41 AM by user591655 RSS

Messages are in READY state in QUEUE TABLE but in AQ$<QUEUE TABLE> messages are in PROCESSED State

user9113644 Newbie
Currently Being Moderated

HI All,


   We create a brand new oracle multi-consumer queue. We have en-queued the messages into the queue and are processed successfully.

   But when we checked the STATE Column  of the messages in the queue table it was showing as "0". But it is showing as "PROCESSED" in the

   AQ$<QUEUE_TABLE> msg_state column.


  We are unable to figure out why there is a mismatch. Can any one help us ?



Hari P.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points