Re: queues

  • From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
  • To: joe_dba@xxxxxxxxxxx
  • Date: Tue, 16 Oct 2007 11:47:01 -0400

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@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
  • References:

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2007