Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: queues
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-lReceived on Tue Oct 16 2007 - 10:47:01 CDT
![]() |
![]() |