2 Replies Latest reply on Apr 28, 2014 12:38 PM by petra-K

    How do I know if my queue is stopped?

      Hi all,

       

      11.2.0.1

       

      Our end-users is complaining that she has queue and dequeue error.

       

      I run this command:

       

      EXEC DBMS_AQADM.START_QUEUE(queue_name => 'MERCHANT_NOTIFY_Q');

      EXEC DBMS_AQADM.START_QUEUE(queue_name => 'AQ$_MERCHANT_NOTIFY_QT_E', enqueue => false);

       

      and the error was resolved.

       

      How do I know when to run the command? or what status does the queue has stopped?

       

       

      Thanks all,

      pK