GV$STREAMS_APPLY_SERVER

select
inst_id,                 -- INST_ID NUMBER
sid_knst,                -- SID NUMBER
serial_knst,             -- SERIAL# NUMBER
applynum_knstasl,        -- APPLY# NUMBER
applyname_knstasl,       -- APPLY_NAME VARCHAR2(30)
slavid_knstasl,          -- SERVER_ID NUMBER
decode                   -- STATE VARCHAR2(20)
  (state_knstasl, 0, 'IDLE', 1, 'POLL SHUTDOWN', 2, 'RECORD LOW-WATERMARK', 3, 'ADD PARTITION', 4, 'DROP PARTITION', 5, 'EXECUTE TRANSACTION', 6, 'WAIT COMMIT', 7, 'WAIT DEPENDENCY', 8, 'GET TRANSACTIONS', 9, 'WAIT FOR NEXT CHUNK', 12, 'ROLLBACK TRANSACTION', 13, 'TRANSACTION CLEANUP', 14, 'REQUEST UA SESSION', 15, 'INITIALIZING'),
xid_usn_knstasl,         -- XIDUSN NUMBER
xid_slt_knstasl,         -- XIDSLT NUMBER
xid_sqn_knstasl,         -- XIDSQN NUMBER
cscn_knstasl,            -- COMMITSCN NUMBER
depxid_usn_knstasl,      -- DEP_XIDUSN NUMBER
depxid_slt_knstasl,      -- DEP_XIDSLT NUMBER
depxid_sqn_knstasl,      -- DEP_XIDSQN NUMBER
depcscn_knstasl,         -- DEP_COMMITSCN NUMBER
msg_num_knstasl,         -- MESSAGE_SEQUENCE NUMBER
total_assigned_knstasl,  -- TOTAL_ASSIGNED NUMBER
total_admin_knstasl,     -- TOTAL_ADMIN NUMBER
total_rollbacks_knstasl, -- TOTAL_ROLLBACKS NUMBER
total_msg_knstasl,       -- TOTAL_MESSAGES_APPLIED NUMBER
last_apply_time_knstasl, -- APPLY_TIME DATE
last_apply_msg_num_knstasl, -- APPLIED_MESSAGE_NUMBER NUMBER
last_apply_msg_time_knstasl, -- APPLIED_MESSAGE_CREATE_TIME DATE
elapsed_dequeue_time_knstasl, -- ELAPSED_DEQUEUE_TIME NUMBER
elapsed_apply_time_knstasl -- ELAPSED_APPLY_TIME NUMBER
  
from
x$knstasl x 
where
type_knst=2 and exists (
select
1 
from
v$session s 
where
s.sid=x.sid_knst and s.serial#=x.serial_knst)
home |  up  |  mailbox