DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.V_$GOLDENGATE_CAPTURE

Object Details
Object Name: V_$GOLDENGATE_CAPTURE
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SID NUMBER

SERIAL# NUMBER

CAPTURE# NUMBER

CAPTURE_NAME VARCHAR2 (30)
LOGMINER_ID NUMBER

STARTUP_TIME DATE

STATE VARCHAR2 (589)
TOTAL_PREFILTER_DISCARDED NUMBER

TOTAL_PREFILTER_KEPT NUMBER

TOTAL_PREFILTER_EVALUATIONS NUMBER

TOTAL_MESSAGES_CAPTURED NUMBER

CAPTURE_TIME DATE

CAPTURE_MESSAGE_NUMBER NUMBER

CAPTURE_MESSAGE_CREATE_TIME DATE

TOTAL_MESSAGES_CREATED NUMBER

TOTAL_FULL_EVALUATIONS NUMBER

TOTAL_MESSAGES_ENQUEUED NUMBER

ENQUEUE_TIME DATE

ENQUEUE_MESSAGE_NUMBER NUMBER

ENQUEUE_MESSAGE_CREATE_TIME DATE

AVAILABLE_MESSAGE_NUMBER NUMBER

AVAILABLE_MESSAGE_CREATE_TIME DATE

ELAPSED_CAPTURE_TIME NUMBER

ELAPSED_RULE_TIME NUMBER

ELAPSED_ENQUEUE_TIME NUMBER

ELAPSED_LCR_TIME NUMBER

ELAPSED_REDO_WAIT_TIME NUMBER

ELAPSED_PAUSE_TIME NUMBER

STATE_CHANGED_TIME DATE

SGA_USED NUMBER

SGA_ALLOCATED NUMBER

BYTES_OF_REDO_MINED VARCHAR2 (64)
SESSION_RESTART_SCN VARCHAR2 (64)
CON_ID NUMBER

SPID VARCHAR2 (12)
EXTRACT_NAME VARCHAR2 (30)
SERVER_SID NUMBER

SERVER_SERIAL# NUMBER

SERVER_SPID VARCHAR2 (12)
TOTAL_MESSAGES_SENT NUMBER

SEND_TIME DATE

LAST_SENT_MESSAGE_NUMBER NUMBER

LAST_SENT_MESSAGE_CREATE_TIME DATE

ELAPSED_SEND_TIME NUMBER

BYTES_SENT NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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 SYS.V_$GOLDENGATE_CAPTURE;

Dependencies

[top of page]

SYS.V_$GOLDENGATE_CAPTURE references the following:

SYS.V_$GOLDENGATE_CAPTURE is referenced by following:

SchemaPUBLIC
SynonymV$GOLDENGATE_CAPTURE