Determining Event Enqueuing Latency

COLUMN LATENCY_SECONDS  FORMAT 9999
COLUMN LAST_STAT_SECS   FORMAT 9999
COLUMN capture_time     FORMAT A18
COLUMN create_mesg_time FORMAT A18
SELECT
 capture_name,
 TO_CHAR(capture_message_create_time, 'HH24:MI:SS MM/DD/YY')
 CREATE_MESG_TIME,
 (SYSDATE - capture_message_create_time ) * 86400 LATENCY_SEC,
 TO_CHAR(capture_time, 'HH24:MI:SS MM/DD/YY') CAPTURE_TIME,
 (SYSDATE - capture_time)*86400 LAST_STAT_SECS,
 total_messages_captured tot_msg_captd,
 total_messages_enqueued tot_msg_enqd
FROM V$STREAMS_CAPTURE
/

SQL Statement Showing Information about Rule Evaluations

Many rule and evaluation statistics are available from the v$streams_capture view. These statistics help users understand the rules evaluation process. Some of the important fields are below: