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

VIEW: SYS.CDB_REPRESOL_STATS_CONTROL

Object Details
Object Name: CDB_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 in all containers

[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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_REPRESOL_STATS_CONTROL;

Dependencies

[top of page]

SYS.CDB_REPRESOL_STATS_CONTROL does not reference any database object

SYS.CDB_REPRESOL_STATS_CONTROL is referenced by following:

SchemaPUBLIC
SynonymCDB_REPRESOL_STATS_CONTROL