GV$STREAMS_APPLY_READER definition in Oracle 9i / www.oracledba.ru
GV$STREAMS_APPLY_READER
select
inst_id, -- INST_ID NUMBER
sid_knst, -- SID NUMBER
serial_knst, -- SERIAL# NUMBER
applynum_knstasl, -- APPLY# NUMBER
applyname_knstasl, -- APPLY_NAME VARCHAR2(30)
decode -- STATE VARCHAR2(17)
(state_knstasl, 0, 'IDLE', 8, 'DEQUEUE MESSAGES', 10, 'SCHEDULE MESSAGES'),
total_msg_knstasl, -- TOTAL_MESSAGES_DEQUEUED NUMBER
last_rcv_time_knstasl, -- DEQUEUE_TIME DATE
last_rcv_msg_num_knstasl, -- DEQUEUED_MESSAGE_NUMBER NUMBER
last_rcv_msg_time_knstasl, -- DEQUEUED_MESSAGE_CREATE_TIME DATE
sga_used_knstasl, -- SGA_USED NUMBER
elapsed_dequeue_time_knstasl, -- ELAPSED_DEQUEUE_TIME NUMBER
elapsed_schedule_time_knstasl -- ELAPSED_SCHEDULE_TIME NUMBER
from
x$knstasl x
where
type_knst=7 and exists (
select
1
from
v$session s
where
s.sid=x.sid_knst and s.serial#=x.serial_knst)