GV$STREAMS_APPLY_SERVER definition in Oracle 9i / www.oracledba.ru
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)