Re: AQ

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 04 Jan 2007 08:35:52 -0800
Message-ID: <1167928552.606759@bubbleator.drizzle.com>

Oradba Linux wrote:
> Is there a dba view which shows the consumers/subscribers for a queue?
>
> oracle 9i 9206

dba_queue_subscribers
user_queue_subscribers

In the future:

SELECT view_name
FROM dba_views
WHERE view_name LIKE '%_QUEUE_%'

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Jan 04 2007 - 10:35:52 CST