VIEW: SYS.V_$GOLDENGATE_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","SGA_USED","SGA_ALLOCATED","BYTES_OF_REDO_MINED","SESSION_RESTART_SCN","CON_ID","SPID","EXTRACT_NAME","SERVER_SID","SERVER_SERIAL#","SERVER_SPID","TOTAL_MESSAGES_SENT","SEND_TIME","LAST_SENT_MESSAGE_NUMBER","LAST_SENT_MESSAGE_CREATE_TIME","ELAPSED_SEND_TIME","BYTES_SENT" from v$goldengate_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"
, "SGA_USED"
, "SGA_ALLOCATED"
, "BYTES_OF_REDO_MINED"
, "SESSION_RESTART_SCN"
, "CON_ID"
, "SPID"
, "EXTRACT_NAME"
, "SERVER_SID"
, "SERVER_SERIAL#"
, "SERVER_SPID"
, "TOTAL_MESSAGES_SENT"
, "SEND_TIME"
, "LAST_SENT_MESSAGE_NUMBER"
, "LAST_SENT_MESSAGE_CREATE_TIME"
, "ELAPSED_SEND_TIME"
, "BYTES_SENT"
FROM V$GOLDENGATE_CAPTURE