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)

home |  up