DBA Data[Home] [Help]

VIEW: SYS.QT439810_BUFFER

Source

View Text - Preformatted

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 X$BUFFER2 WHERE objno = 439810
View Text - HTML Formatted

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 X$BUFFER2
WHERE OBJNO = 439810