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_REPRESOL_STATS_CONTROL

Object Details

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

Information about statistics collection for conflict resolutions for all replicated tables in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SNAME	VARCHAR2	(128)	Yes	Owner of replicated object
ONAME	VARCHAR2	(128)	Yes	Name of the replicated object
CREATED	DATE		Yes	Timestamp for which statistics collection was first started
STATUS	VARCHAR2	(9)		Status of statistics collection: ACTIVE, CANCELLED
STATUS_UPDATE_DATE	DATE		Yes	Timestamp for which the status was last updated
PURGED_DATE	DATE			Timestamp for the last purge of statistics data
LAST_PURGE_START_DATE	DATE			The last start date of the statistics purging date range
LAST_PURGE_END_DATE	DATE			The last end date of the statistics purging date range

Query Text

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


SELECT SNAME
,      ONAME
,      CREATED
,      STATUS
,      STATUS_UPDATE_DATE
,      PURGED_DATE
,      LAST_PURGE_START_DATE
,      LAST_PURGE_END_DATE
FROM SYS.DBA_REPRESOL_STATS_CONTROL;

Dependencies

[top of page]

SYS.DBA_REPRESOL_STATS_CONTROL references the following:

SYSTEM: REPCAT$_RESOL_STATS_CONTROL

SYS.DBA_REPRESOL_STATS_CONTROL is referenced by following:

PUBLIC: DBA_REPRESOL_STATS_CONTROL