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]

TABLE: SYSTEM.AQ$_QUEUES

Object Details

Object Name:	AQ$_QUEUES
Object Type:	TABLE
Owner:	SYSTEM
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: AQ$_QUEUES_PRIMARY

Unique Key: AQ$_QUEUES_CHECK

NAME
TABLE_OBJNO

Indexes

Index	Type	Uniqueness	Tablespace	Column
AQ$_QUEUES_CHECK	NORMAL	UNIQUE	SYSTEM	NAME TABLE_OBJNO
AQ$_QUEUES_PRIMARY	NORMAL	UNIQUE	SYSTEM	OID
SYS_IL0000002395C00012$$	LOB	UNIQUE	SYSTEM
I1_QUEUES	NORMAL	NONUNIQUE	SYSTEM	NAME EVENTID TABLE_OBJNO

Columns

Name	Datatype	Length	Mandatory
OID	RAW	(16)	Yes
EVENTID	NUMBER		Yes
NAME	VARCHAR2	(128)	Yes
TABLE_OBJNO	NUMBER		Yes
USAGE	NUMBER		Yes
ENABLE_FLAG	NUMBER		Yes
MAX_RETRIES	NUMBER
RETRY_DELAY	NUMBER
PROPERTIES	NUMBER
RET_TIME	NUMBER
QUEUE_COMMENT	VARCHAR2	(2000)
SUBSCRIBERS	AQ$_SUBSCRIBERS	(3852)
MEMORY_THRESHOLD	NUMBER
SERVICE_NAME	VARCHAR2	(64)
NETWORK_NAME	VARCHAR2	(256)
SUB_OID	RAW	(16)
SHARDED	NUMBER

Query Text

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


SELECT OID
,      EVENTID
,      NAME
,      TABLE_OBJNO
,      USAGE
,      ENABLE_FLAG
,      MAX_RETRIES
,      RETRY_DELAY
,      PROPERTIES
,      RET_TIME
,      QUEUE_COMMENT
,      SUBSCRIBERS
,      MEMORY_THRESHOLD
,      SERVICE_NAME
,      NETWORK_NAME
,      SUB_OID
,      SHARDED
FROM SYSTEM.AQ$_QUEUES;

Dependencies

[top of page]

SYSTEM.AQ$_QUEUES references the following:

SYS: AQ$_SUBSCRIBERS; STANDARD - show dependent code

SYSTEM.AQ$_QUEUES is referenced by following:

SYS: ALL_DEQUEUE_QUEUES; ALL_INT_DEQUEUE_QUEUES; ALL_QUEUES; ALL_QUEUE_PUBLISHERS; ALL_QUEUE_SUBSCRIBERS; ALL_QUEUE_TABLES; AQ$_GET_SUBSCRIBERS; DBA_QUEUES; DBA_QUEUE_PUBLISHERS; DBA_QUEUE_SUBSCRIBERS; DBMS_APPLY_ERROR - show dependent code; DBMS_AQADM_SYS - show dependent code; DBMS_AQ_IMPORT_INTERNAL - show dependent code; DBMS_AQ_SYS_EXP_ACTIONS - show dependent code; DBMS_AQ_SYS_EXP_INTERNAL - show dependent code; DBMS_AQ_SYS_IMP_INTERNAL - show dependent code; DBMS_LOGREP_UTIL - show dependent code; DBMS_PRVTAQIM - show dependent code; DBMS_PRVTAQIP - show dependent code; DBMS_PRVTAQIS - show dependent code; KU$_QUEUES_VIEW; USER_QUEUES; USER_QUEUE_PUBLISHERS; USER_QUEUE_SUBSCRIBERS; _ALL_QUEUE_CACHED_MESSAGES; _ALL_QUEUE_SCHEDULES; _DBA_QUEUE_SCHEDULES; _DBA_QUEUE_SCHEDULES_COMPAT; _DBA_QUEUE_STATS1; _DBA_STREAMS_COMPONENT; _DBA_STREAMS_COMPONENT_STAT; _USER_QUEUE_SCHEDULES; _USER_QUEUE_SCHEDULES_COMPAT