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