eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.USER_QUEUE_SUBSCRIBERS

Object Details

Object Name:	USER_QUEUE_SUBSCRIBERS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

queue subscribers under a user'schema

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
QUEUE_NAME	VARCHAR2	(128)	Yes	name of the queue
QUEUE_TABLE	VARCHAR2	(128)	Yes	name of the queue table
CONSUMER_NAME	VARCHAR2	(30)		name of the subscriber
ADDRESS	VARCHAR2	(1024)		address of the subscriber
PROTOCOL	NUMBER			protocol of the subscriber
TRANSFORMATION	VARCHAR2	(61)		transformation for the subscriber
RULE	CLOB	(4000)		rule condition for the subscriber
DELIVERY_MODE	VARCHAR2	(22)		message delivery mode for the subscriber
NONDURABLE	VARCHAR2	(3)
QUEUE_TO_QUEUE	VARCHAR2	(5)		whether the subscriber is a queue to queue subscriber
SUBSCRIBER_ID	NUMBER			id of subscriber
POS_BITMAP	NUMBER			position of subscriber in the bitmap

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QUEUE_NAME
,      QUEUE_TABLE
,      CONSUMER_NAME
,      ADDRESS
,      PROTOCOL
,      TRANSFORMATION
,      RULE
,      DELIVERY_MODE
,      NONDURABLE
,      QUEUE_TO_QUEUE
,      SUBSCRIBER_ID
,      POS_BITMAP
FROM SYS.USER_QUEUE_SUBSCRIBERS;

Dependencies

[top of page]

SYS.USER_QUEUE_SUBSCRIBERS references the following:

SYS: AQ$_GET_SUBSCRIBERS; AQ$_SUBSCRIBER_T; USER$; USER_RULES
SYSTEM: AQ$_QUEUES; AQ$_QUEUE_TABLES

SYS.USER_QUEUE_SUBSCRIBERS is referenced by following:

PUBLIC: USER_QUEUE_SUBSCRIBERS