eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS._DBA_APPLY_TABLE_STATS

Object Details

Object Name:	_DBA_APPLY_TABLE_STATS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
APPLY#	NUMBER
SERVER_ID	NUMBER
SAVE_TIME	DATE
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
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
SPARE1	NUMBER
SPARE2	NUMBER
SPARE3	NUMBER
SPARE4	NUMBER
SPARE5	NUMBER
SPARE6	NUMBER
SPARE7	NUMBER
SPARE8	NUMBER
SPARE9	NUMBER
SPARE10	NUMBER
SPARE11	VARCHAR2	(4000)
SPARE12	VARCHAR2	(4000)
SPARE13	VARCHAR2	(4000)
SPARE14	VARCHAR2	(4000)
SPARE15	RAW	(1000)
SPARE16	RAW	(1000)
SPARE17	RAW	(1000)
SPARE18	DATE
SPARE19	DATE
SPARE20	DATE

Query Text

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


SELECT APPLY#
,      SERVER_ID
,      SAVE_TIME
,      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
,      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
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
,      SPARE7
,      SPARE8
,      SPARE9
,      SPARE10
,      SPARE11
,      SPARE12
,      SPARE13
,      SPARE14
,      SPARE15
,      SPARE16
,      SPARE17
,      SPARE18
,      SPARE19
,      SPARE20
FROM SYS._DBA_APPLY_TABLE_STATS;

Dependencies

[top of page]

SYS._DBA_APPLY_TABLE_STATS references the following:

SYS: APPLY$_TABLE_STATS

SYS._DBA_APPLY_TABLE_STATS is not referenced by any database object