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: OKC.AQ$OKC_AQ_EV_TAB

Object Details

Object Name:	AQ$OKC_AQ_EV_TAB
Object Type:	VIEW
Owner:	OKC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)	(20)
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(9)	(20)
DEQ_USER_ID	NUMBER
DEQ_TXN_ID	VARCHAR2	(30)
RETRY_COUNT	NUMBER
EXCEPTION_QUEUE_OWNER	VARCHAR2	(30)
EXCEPTION_QUEUE	VARCHAR2	(30)
USER_DATA	OKC_AQ_MSG_TYP	(64)
PROPAGATED_MSGID	RAW	(16)
SENDER_NAME	VARCHAR2	(30)
SENDER_ADDRESS	VARCHAR2	(1024)
SENDER_PROTOCOL	NUMBER
ORIGINAL_MSGID	RAW	(16)
ORIGINAL_QUEUE_NAME	VARCHAR2	(30)
ORIGINAL_QUEUE_OWNER	VARCHAR2	(30)
EXPIRATION_REASON	VARCHAR2	(31)
CONSUMER_NAME	VARCHAR2	(30)
ADDRESS	VARCHAR2	(1024)
PROTOCOL	NUMBER

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
,      PROPAGATED_MSGID
,      SENDER_NAME
,      SENDER_ADDRESS
,      SENDER_PROTOCOL
,      ORIGINAL_MSGID
,      ORIGINAL_QUEUE_NAME
,      ORIGINAL_QUEUE_OWNER
,      EXPIRATION_REASON
,      CONSUMER_NAME
,      ADDRESS
,      PROTOCOL
FROM OKC.AQ$OKC_AQ_EV_TAB;

Dependencies

[top of page]

OKC.AQ$OKC_AQ_EV_TAB references the following:

OKC: AQ$_OKC_AQ_EV_TAB_H; AQ$_OKC_AQ_EV_TAB_L; AQ$_OKC_AQ_EV_TAB_S; OKC_AQ_EV_TAB
SYS: STANDARD - show dependent code
SYSTEM: OKC_AQ_MSG_TYP

OKC.AQ$OKC_AQ_EV_TAB is referenced by following:

APPS: AQ$OKC_AQ_EV_TAB