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 x WHERE objno = 629904
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 X
WHERE OBJNO = 629904
|
|
|