[Home] [Help] [Dependency Information]
Object Name: | GV_$GOLDENGATE_TABLE_STATS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, 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.GV_$GOLDENGATE_TABLE_STATS;
|
|
|