In an oracle 11.2 RAC database, after re-bounce database, dequeue takes 3 - 12 hours. When attempt t

I am referencing the Oracle Doc ID 331372.1 to investigate the issue.

1.

I run the following query to find out how many messages are in the notification queue but not in the user-created application queue

SELECT msgid notify_msgid,

TO_CHAR (n.enq_time, 'DD-MON-YYYY hh24:mi:ss'),

n.user_data.msg_id app_msgid,

n.user_data.queue_name qname,

NVL (UTL_RAW.cast_to_varchar2 (n.user_data.payload), 'null') payload

FROM sys.AQ_SRVNTFN_TABLE_1 n

WHERE n.user_data.msg_id IN (SELECT n.user_data.msg_id msgid

FROM sys.AQ_SRVNTFN_TABLE_1 n

MINUS

SELECT msgid