COLUMN APPLY_NAME FORMAT A30
COLUMN STATE FORMAT A20
COLUMN TRANSACTION_ID FORMAT A20
COLUMN COMMITSCN FORMAT 999999999999999
COLUMN TOTAL_MSG_APPLIED FORMAT 999999999999

select sid,serial#,capture#,capture_name,to_char(startup_time,'dd/mm/yyyy hh24:mi:ss') startup_time,state,
TOTAL_PREFILTER_DISCARDED msg_discad,TOTAL_PREFILTER_EVALUATIONS msg_eval,TOTAL_MESSAGES_CAPTURED msg_captured  
from V$STREAMS_CAPTURE;