GV$STREAMS_APPLY_SERVER definition in Oracle Database 11.2
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',16,'SPILL',18,'WAIT FOR CLIENT'),
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
commit_position_knstasl, -- COMMIT_POSITION RAW(64)
dep_commit_position_knstasl, -- DEP_COMMIT_POSITION RAW(64)
last_apply_pos_knstasl, -- LAST_APPLY_POSITION RAW(64)
nosxid_knstasl, -- TRANSACTION_ID VARCHAR2(128)
depnosxid_knstasl -- DEP_TRANSACTION_ID VARCHAR2(128)
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)