[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
- OID
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 |
Comments |
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