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

VIEW: SYS.V_$GOLDENGATE_TABLE_STATS

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLY_NAME VARCHAR2 (30)
SERVER_ID NUMBER

SOURCE_TABLE_OWNER VARCHAR2 (30)
SOURCE_TABLE_NAME VARCHAR2 (30)
DESTINATION_TABLE_OWNER VARCHAR2 (30)
DESTINATION_TABLE_NAME VARCHAR2 (30)
LAST_UPDATE DATE

TOTAL_INSERTS NUMBER

TOTAL_UPDATES NUMBER

TOTAL_DELETES NUMBER

INSERT_COLLISIONS NUMBER

UPDATE_COLLISIONS NUMBER

DELETE_COLLISIONS NUMBER

REPERROR_RECORDS NUMBER

REPERROR_IGNORES NUMBER

WAIT_DEPENDENCIES NUMBER

CON_ID NUMBER

CDR_INSERT_ROW_EXISTS NUMBER

CDR_UPDATE_ROW_EXISTS NUMBER

CDR_UPDATE_ROW_MISSING NUMBER

CDR_DELETE_ROW_EXISTS NUMBER

CDR_DELETE_ROW_MISSING NUMBER

CDR_SUCCESSFUL_RESOLUTIONS NUMBER

CDR_FAILED_RESOLUTIONS NUMBER

LOB_OPERATIONS NUMBER

Query Text

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


SELECT APPLY_NAME
,      SERVER_ID
,      SOURCE_TABLE_OWNER
,      SOURCE_TABLE_NAME
,      DESTINATION_TABLE_OWNER
,      DESTINATION_TABLE_NAME
,      LAST_UPDATE
,      TOTAL_INSERTS
,      TOTAL_UPDATES
,      TOTAL_DELETES
,      INSERT_COLLISIONS
,      UPDATE_COLLISIONS
,      DELETE_COLLISIONS
,      REPERROR_RECORDS
,      REPERROR_IGNORES
,      WAIT_DEPENDENCIES
,      CON_ID
,      CDR_INSERT_ROW_EXISTS
,      CDR_UPDATE_ROW_EXISTS
,      CDR_UPDATE_ROW_MISSING
,      CDR_DELETE_ROW_EXISTS
,      CDR_DELETE_ROW_MISSING
,      CDR_SUCCESSFUL_RESOLUTIONS
,      CDR_FAILED_RESOLUTIONS
,      LOB_OPERATIONS
FROM SYS.V_$GOLDENGATE_TABLE_STATS;

Dependencies

[top of page]

SYS.V_$GOLDENGATE_TABLE_STATS references the following:

SYS.V_$GOLDENGATE_TABLE_STATS is referenced by following:

SchemaPUBLIC
SynonymV$GOLDENGATE_TABLE_STATS