VIEW: SYS.V_$STREAMS_CAPTURE

Source

View Text - Preformatted

select "SID","SERIAL#","CAPTURE#","CAPTURE_NAME","LOGMINER_ID","STARTUP_TIME","STATE","TOTAL_PREFILTER_DISCARDED","TOTAL_PREFILTER_KEPT","TOTAL_PREFILTER_EVALUATIONS","TOTAL_MESSAGES_CAPTURED","CAPTURE_TIME","CAPTURE_MESSAGE_NUMBER","CAPTURE_MESSAGE_CREATE_TIME","TOTAL_MESSAGES_CREATED","TOTAL_FULL_EVALUATIONS","TOTAL_MESSAGES_ENQUEUED","ENQUEUE_TIME","ENQUEUE_MESSAGE_NUMBER","ENQUEUE_MESSAGE_CREATE_TIME","AVAILABLE_MESSAGE_NUMBER","AVAILABLE_MESSAGE_CREATE_TIME","ELAPSED_CAPTURE_TIME","ELAPSED_RULE_TIME","ELAPSED_ENQUEUE_TIME","ELAPSED_LCR_TIME","ELAPSED_REDO_WAIT_TIME","ELAPSED_PAUSE_TIME","STATE_CHANGED_TIME","APPLY_NAME","APPLY_DBLINK","APPLY_MESSAGES_SENT","APPLY_BYTES_SENT","OPTIMIZATION","PURPOSE","SGA_USED","SGA_ALLOCATED","BYTES_OF_REDO_MINED","SESSION_RESTART_SCN","CON_ID" from v$streams_capture

View Text - HTML Formatted

SELECT "SID"
, "SERIAL#"
, "CAPTURE#"
, "CAPTURE_NAME"
, "LOGMINER_ID"
, "STARTUP_TIME"
, "STATE"
, "TOTAL_PREFILTER_DISCARDED"
, "TOTAL_PREFILTER_KEPT"
, "TOTAL_PREFILTER_EVALUATIONS"
, "TOTAL_MESSAGES_CAPTURED"
, "CAPTURE_TIME"
, "CAPTURE_MESSAGE_NUMBER"
, "CAPTURE_MESSAGE_CREATE_TIME"
, "TOTAL_MESSAGES_CREATED"
, "TOTAL_FULL_EVALUATIONS"
, "TOTAL_MESSAGES_ENQUEUED"
, "ENQUEUE_TIME"
, "ENQUEUE_MESSAGE_NUMBER"
, "ENQUEUE_MESSAGE_CREATE_TIME"
, "AVAILABLE_MESSAGE_NUMBER"
, "AVAILABLE_MESSAGE_CREATE_TIME"
, "ELAPSED_CAPTURE_TIME"
, "ELAPSED_RULE_TIME"
, "ELAPSED_ENQUEUE_TIME"
, "ELAPSED_LCR_TIME"
, "ELAPSED_REDO_WAIT_TIME"
, "ELAPSED_PAUSE_TIME"
, "STATE_CHANGED_TIME"
, "APPLY_NAME"
, "APPLY_DBLINK"
, "APPLY_MESSAGES_SENT"
, "APPLY_BYTES_SENT"
, "OPTIMIZATION"
, "PURPOSE"
, "SGA_USED"
, "SGA_ALLOCATED"
, "BYTES_OF_REDO_MINED"
, "SESSION_RESTART_SCN"
, "CON_ID"
FROM V$STREAMS_CAPTURE