DBA Data[Home] [Help]

VIEW: SYS.AQ$_UNFLUSHED_DEQUEUES

Source

View Text - Preformatted

select ADDR, INDX, QTOBJNO, MSGID, SUBSCRIBER#, NAME, DEQUEUE_TIME,
TRANSACTION_ID, DEQUEUE_USER, FLAGS from x$unflushed_dequeues
View Text - HTML Formatted

SELECT ADDR
, INDX
, QTOBJNO
, MSGID
, SUBSCRIBER#
, NAME
, DEQUEUE_TIME
, TRANSACTION_ID
, DEQUEUE_USER
, FLAGS
FROM X$UNFLUSHED_DEQUEUES