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

VIEW: APPLSYS.AQ$ECX_OUTQUEUE

Object Details
Object Name: AQ$ECX_OUTQUEUE
Object Type: VIEW
Owner: APPLSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
QUEUE VARCHAR2 (30)
MSG_ID RAW (16) Yes
CORR_ID VARCHAR2 (128)
MSG_PRIORITY NUMBER

MSG_STATE VARCHAR2 (16)
DELAY DATE

DELAY_TIMESTAMP TIMESTAMP(6) (11)
EXPIRATION NUMBER

ENQ_TIME DATE

ENQ_TIMESTAMP TIMESTAMP(6) (20)
ENQ_USER_ID NUMBER

ENQ_TXN_ID VARCHAR2 (30)
DEQ_TIME DATE

DEQ_TIMESTAMP TIMESTAMP(6) (20)
DEQ_USER_ID NUMBER

DEQ_TXN_ID VARCHAR2 (30)
RETRY_COUNT NUMBER

EXCEPTION_QUEUE_OWNER VARCHAR2 (30)
EXCEPTION_QUEUE VARCHAR2 (30)
USER_DATA ECXMSG (64)
ORIGINAL_QUEUE_NAME VARCHAR2 (30)
ORIGINAL_QUEUE_OWNER VARCHAR2 (30)
EXPIRATION_REASON VARCHAR2 (18)
SENDER_NAME VARCHAR2 (30)
SENDER_ADDRESS VARCHAR2 (1024)
SENDER_PROTOCOL NUMBER

ORIGINAL_MSGID RAW (16)
Query Text

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


SELECT QUEUE
,      MSG_ID
,      CORR_ID
,      MSG_PRIORITY
,      MSG_STATE
,      DELAY
,      DELAY_TIMESTAMP
,      EXPIRATION
,      ENQ_TIME
,      ENQ_TIMESTAMP
,      ENQ_USER_ID
,      ENQ_TXN_ID
,      DEQ_TIME
,      DEQ_TIMESTAMP
,      DEQ_USER_ID
,      DEQ_TXN_ID
,      RETRY_COUNT
,      EXCEPTION_QUEUE_OWNER
,      EXCEPTION_QUEUE
,      USER_DATA
,      ORIGINAL_QUEUE_NAME
,      ORIGINAL_QUEUE_OWNER
,      EXPIRATION_REASON
,      SENDER_NAME
,      SENDER_ADDRESS
,      SENDER_PROTOCOL
,      ORIGINAL_MSGID
FROM APPLSYS.AQ$ECX_OUTQUEUE;

Dependencies

[top of page]

APPLSYS.AQ$ECX_OUTQUEUE references the following:

SchemaAPPLSYS
TableECX_OUTQUEUE
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
SchemaSYSTEM
TYPEECXMSG

APPLSYS.AQ$ECX_OUTQUEUE is not referenced by any database object