V$STREAMS_APPLY_READER definition in Oracle Database 11.2
V$STREAMS_APPLY_READER

select
  SID,                                     -- SID NUMBER
  SERIAL#,                                 -- SERIAL# NUMBER
  APPLY#,                                  -- APPLY# NUMBER
  APPLY_NAME,                              -- APPLY_NAME VARCHAR2(30)
  STATE,                                   -- STATE VARCHAR2(36)
  TOTAL_MESSAGES_DEQUEUED,                 -- TOTAL_MESSAGES_DEQUEUED NUMBER
  TOTAL_MESSAGES_SPILLED,                  -- TOTAL_MESSAGES_SPILLED NUMBER
  DEQUEUE_TIME,                            -- DEQUEUE_TIME DATE
  DEQUEUED_MESSAGE_NUMBER,                 -- DEQUEUED_MESSAGE_NUMBER NUMBER
  DEQUEUED_MESSAGE_CREATE_TIME,            -- DEQUEUED_MESSAGE_CREATE_TIME DATE
  SGA_USED,                                -- SGA_USED NUMBER
  ELAPSED_DEQUEUE_TIME,                    -- ELAPSED_DEQUEUE_TIME NUMBER
  ELAPSED_SCHEDULE_TIME,                   -- ELAPSED_SCHEDULE_TIME NUMBER
  ELAPSED_SPILL_TIME,                      -- ELAPSED_SPILL_TIME NUMBER
  LAST_BROWSE_NUM,                         -- LAST_BROWSE_NUM NUMBER
  OLDEST_SCN_NUM,                          -- OLDEST_SCN_NUM NUMBER
  LAST_BROWSE_SEQ,                         -- LAST_BROWSE_SEQ NUMBER
  LAST_DEQ_SEQ,                            -- LAST_DEQ_SEQ NUMBER
  OLDEST_XIDUSN,                           -- OLDEST_XIDUSN NUMBER
  OLDEST_XIDSLT,                           -- OLDEST_XIDSLT NUMBER
  OLDEST_XIDSQN,                           -- OLDEST_XIDSQN NUMBER
  SPILL_LWM_SCN,                           -- SPILL_LWM_SCN NUMBER
  PROXY_SID,                               -- PROXY_SID NUMBER
  PROXY_SERIAL,                            -- PROXY_SERIAL NUMBER
  PROXY_SPID,                              -- PROXY_SPID VARCHAR2(12)
  CAPTURE_BYTES_RECEIVED,                  -- CAPTURE_BYTES_RECEIVED NUMBER
  DEQUEUED_POSITION,                       -- DEQUEUED_POSITION RAW(64)
  LAST_BROWSE_POSITION,                    -- LAST_BROWSE_POSITION RAW(64)
  OLDEST_POSITION,                         -- OLDEST_POSITION RAW(64)
  SPILL_LWM_POSITION,                      -- SPILL_LWM_POSITION RAW(64)
  OLDEST_TRANSACTION_ID                    -- OLDEST_TRANSACTION_ID VARCHAR2(128)
from
  GV$STREAMS_APPLY_READER
where
  INST_ID = USERENV('Instance')

home |  up