GV$STREAMS_CAPTURE

select
inst_id,                 -- INST_ID NUMBER
sid_knst,                -- SID NUMBER
serial_knst,             -- SERIAL# NUMBER
capnum_knstcap,          -- CAPTURE# NUMBER
capname_knstcap,         -- CAPTURE_NAME VARCHAR2(30)
startup_time_knstcap,    -- STARTUP_TIME DATE
decode                   -- STATE VARCHAR2(17)
  (state_knstcap, 0, 'INITIALIZING', 1, 'CAPTURING CHANGES', 2, 'EVALUATING RULE', 3, 'ENQUEUING MESSAGE', 4, 'SHUTTING DOWN', 5, 'ABORTING', 6, 'CREATING LCR'),
total_captured_knstcap,  -- TOTAL_MESSAGES_CAPTURED NUMBER
recent_time_knstcap,     -- CAPTURE_TIME DATE
recent_msg_num_knstcap,  -- CAPTURE_MESSAGE_NUMBER NUMBER
recent_msg_time_knstcap, -- CAPTURE_MESSAGE_CREATE_TIME DATE
total_msg_enq_knstcap,   -- TOTAL_MESSAGES_ENQUEUED NUMBER
enqueue_time_knstcap,    -- ENQUEUE_TIME DATE
enqueue_msg_num_knstcap, -- ENQUEUE_MESSAGE_NUMBER NUMBER
enqueue_msg_time_knstcap, -- ENQUEUE_MESSAGE_CREATE_TIME DATE
elapsed_capture_time_knstcap, -- ELAPSED_CAPTURE_TIME NUMBER
elapsed_rule_time_knstcap, -- ELAPSED_RULE_TIME NUMBER
elapsed_enqueue_time_knstcap, -- ELAPSED_ENQUEUE_TIME NUMBER
elapsed_lcr_time_knstcap -- ELAPSED_LCR_TIME NUMBER
  
from
x$knstcap x 
where
type_knst=8 and exists (
select
1 
from
v$session s 
where
s.sid=x.sid_knst and s.serial#=x.serial_knst)
home |  up  |  mailbox