Re: queues

From: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Tue, 16 Oct 2007 11:47:01 -0400
Message-ID: <49d668000710160847q50857ed0rf1cebfe38300cfc7@mail.gmail.com>

Actually it's not a binary state -- the query can be enabled (started) for dequeue and/or enqueue -- hence you should reference enqueue_enabled and dequeue_enabled columns in a dba_queues or user_queues.

You can also notice that dbms_aqadm.stop_queue and dbms_aqadm.start_queue can accepts a separate argument for dequeue/enqueue.

On 10/16/07, Joe Smith <joe_dba_at_hotmail.com> wrote:
>
> How can you tell if a queue has been stopped or started? Besides the
> explicit command of course.
>
> I have looked in dba_queues, v$aq, dba_queue_tables, and the metalink doc
> ID#102330.1.
>
>
> thanks.
>
> ________________________________
> Peek-a-boo FREE Tricks & Treats for You! Get 'em!

-- 
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 16 2007 - 10:47:01 CDT