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]

TABLE: SYS.APPLY$_TABLE_STATS

Object Details

Object Name:	APPLY$_TABLE_STATS
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
APPLY$_TABLE_STATS_I	NORMAL	NONUNIQUE	SYSTEM	APPLY# SERVER_ID SAVE_TIME

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
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
LOB_OPERATIONS	NUMBER

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

Dependencies

[top of page]

SYS.APPLY$_TABLE_STATS does not reference any database object

SYS.APPLY$_TABLE_STATS is referenced by following:

SYS: _DBA_APPLY_TABLE_STATS