DBA Data[Home] [Help]

VIEW: SYS.DBA_HIST_CAPTURE

Source

View Text - Preformatted

select "SNAP_ID","DBID","INSTANCE_NUMBER","CAPTURE_NAME","STARTUP_TIME","LAG","TOTAL_MESSAGES_CAPTURED","TOTAL_MESSAGES_ENQUEUED","ELAPSED_RULE_TIME","ELAPSED_ENQUEUE_TIME","ELAPSED_REDO_WAIT_TIME","ELAPSED_PAUSE_TIME","CON_DBID","EXTRACT_NAME","BYTES_REDO_MINED","BYTES_SENT","SESSION_MODULE","CON_ID" from INT$DBA_HIST_CAPTURE
View Text - HTML Formatted

SELECT "SNAP_ID"
, "DBID"
, "INSTANCE_NUMBER"
, "CAPTURE_NAME"
, "STARTUP_TIME"
, "LAG"
, "TOTAL_MESSAGES_CAPTURED"
, "TOTAL_MESSAGES_ENQUEUED"
, "ELAPSED_RULE_TIME"
, "ELAPSED_ENQUEUE_TIME"
, "ELAPSED_REDO_WAIT_TIME"
, "ELAPSED_PAUSE_TIME"
, "CON_DBID"
, "EXTRACT_NAME"
, "BYTES_REDO_MINED"
, "BYTES_SENT"
, "SESSION_MODULE"
, "CON_ID"
FROM INT$DBA_HIST_CAPTURE