GV$STREAMS_APPLY_READER

select
inst_id,                 -- INST_ID NUMBER
sid_knst,                -- SID NUMBER
serial_knst,             -- SERIAL# NUMBER
applynum_knstasl,        -- APPLY# NUMBER
applyname_knstasl,       -- APPLY_NAME VARCHAR2(30)
decode                   -- STATE VARCHAR2(17)
  (state_knstasl, 0, 'IDLE', 8, 'DEQUEUE MESSAGES', 10, 'SCHEDULE MESSAGES', 15, 'INITIALIZING', 16, 'SPILLING', 17, 'PAUSED'),
total_msg_knstasl,       -- TOTAL_MESSAGES_DEQUEUED NUMBER
total_spill_msg_knstasl, -- TOTAL_MESSAGES_SPILLED NUMBER
last_rcv_time_knstasl,   -- DEQUEUE_TIME DATE
last_rcv_msg_num_knstasl, -- DEQUEUED_MESSAGE_NUMBER NUMBER
last_rcv_msg_time_knstasl, -- DEQUEUED_MESSAGE_CREATE_TIME DATE
sga_used_knstasl,        -- SGA_USED NUMBER
elapsed_dequeue_time_knstasl, -- ELAPSED_DEQUEUE_TIME NUMBER
elapsed_schedule_time_knstasl, -- ELAPSED_SCHEDULE_TIME NUMBER
elapsed_spill_time_knstasl, -- ELAPSED_SPILL_TIME NUMBER
last_browse_num_knstasl, -- LAST_BROWSE_NUM NUMBER
oldest_scn_num_knstasl,  -- OLDEST_SCN_NUM NUMBER
last_browse_seq_knstasl, -- LAST_BROWSE_SEQ NUMBER
last_deq_seq_knstasl,    -- LAST_DEQ_SEQ NUMBER
oldest_xid_usn_knstasl,  -- OLDEST_XIDUSN NUMBER
oldest_xid_slt_knstasl,  -- OLDEST_XIDSLT NUMBER
oldest_xid_sqn_knstasl   -- OLDEST_XIDSQN NUMBER
from
x$knstasl x 
where
type_knst=7 and exists (
select
1 
from
v$session s 
where
s.sid=x.sid_knst and s.serial#=x.serial_knst)
home |  up  |  mailbox