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_REPRESOLUTION_STATISTICS

Object Details

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

Statistics 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
CONFLICT_TYPE	VARCHAR2	(10)		Type of conflict
REFERENCE_NAME	VARCHAR2	(128)	Yes	Table name, unique constraint name, or column group name
METHOD_NAME	VARCHAR2	(80)	Yes	Name of the conflict resolution method
FUNCTION_NAME	VARCHAR2	(386)		Name of the resolution function
PRIORITY_GROUP	VARCHAR2	(30)		Name of the priority group used in conflict resolution
RESOLVED_DATE	DATE		Yes	Timestamp for the resolution of the conflict
PRIMARY_KEY_VALUE	VARCHAR2	(2000)	Yes	Primary key of the replicated row (character data)

Query Text

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


SELECT SNAME
,      ONAME
,      CONFLICT_TYPE
,      REFERENCE_NAME
,      METHOD_NAME
,      FUNCTION_NAME
,      PRIORITY_GROUP
,      RESOLVED_DATE
,      PRIMARY_KEY_VALUE
FROM SYS.DBA_REPRESOLUTION_STATISTICS;

Dependencies

[top of page]

SYS.DBA_REPRESOLUTION_STATISTICS references the following:

SYSTEM: REPCAT$_RESOLUTION_STATISTICS

SYS.DBA_REPRESOLUTION_STATISTICS is referenced by following:

PUBLIC: DBA_REPRESOLUTION_STATISTICS