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.USER_REPRESOL_STATS_CONTROL

Object Details

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

Information about statistics collection for conflict resolutions for user's replicated tables

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
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 ONAME
,      CREATED
,      STATUS
,      STATUS_UPDATE_DATE
,      PURGED_DATE
,      LAST_PURGE_START_DATE
,      LAST_PURGE_END_DATE
FROM SYS.USER_REPRESOL_STATS_CONTROL;

Dependencies

[top of page]

SYS.USER_REPRESOL_STATS_CONTROL references the following:

SYS: USER$
SYSTEM: REPCAT$_RESOL_STATS_CONTROL

SYS.USER_REPRESOL_STATS_CONTROL is referenced by following:

PUBLIC: USER_REPRESOL_STATS_CONTROL