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'), 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_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