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.QT245562_BUFFER

Object Details

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

[View Source]

Columns

Name	Datatype	Length
ADDR	RAW	(8)
INDX	NUMBER
INST_ID	NUMBER
OBJNO	NUMBER
QUEUE_ID	NUMBER
MSGID	RAW	(16)
CORRID	VARCHAR2	(128)
SEQUENCE_NUM	NUMBER
MSG_NUM	NUMBER
STATE	NUMBER
PRIORITY	NUMBER
EXPIRATION	NUMBER
ENQ_TIME	TIMESTAMP(6)	(20)
ENQ_UID	NUMBER
ENQ_USER_NAME	VARCHAR2	(30)
RETRY_COUNT	NUMBER
SENDER_NAME	VARCHAR2	(30)
SENDER_ADDRESS	VARCHAR2	(1024)
SENDER_PROTOCOL	NUMBER
DEQUEUE_MSGID	RAW	(16)
SRCSEQUENCE_NUM	NUMBER
SUBSCRIBER_ID	NUMBER
EXCEPTIONQ_SCHEMA	VARCHAR2	(30)
EXCEPTIONQ_NAME	VARCHAR2	(30)

Query Text

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


SELECT ADDR
,      INDX
,      INST_ID
,      OBJNO
,      QUEUE_ID
,      MSGID
,      CORRID
,      SEQUENCE_NUM
,      MSG_NUM
,      STATE
,      PRIORITY
,      EXPIRATION
,      ENQ_TIME
,      ENQ_UID
,      ENQ_USER_NAME
,      RETRY_COUNT
,      SENDER_NAME
,      SENDER_ADDRESS
,      SENDER_PROTOCOL
,      DEQUEUE_MSGID
,      SRCSEQUENCE_NUM
,      SUBSCRIBER_ID
,      EXCEPTIONQ_SCHEMA
,      EXCEPTIONQ_NAME
FROM SYS.QT245562_BUFFER;

Dependencies

[top of page]

SYS.QT245562_BUFFER references the following:

SYS.QT245562_BUFFER is referenced by following:

APPLSYS: AQ$WF_CONTROL; AQ$_WF_CONTROL_F