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

TABLE: SYSTEM.REPCAT$_RESOL_STATS_CONTROL

Object Details
Object Name: REPCAT$_RESOL_STATS_CONTROL
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: REPCAT$_RESOL_STATS_CTRL_PK
  1. ColumnSNAME
  2. ColumnONAME
Indexes
Index Type Uniqueness Tablespace Column
REPCAT$_RESOL_STATS_CTRL_PK NORMAL UNIQUE TablespaceSYSTEM ColumnSNAME
ColumnONAME
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 NUMBER
Yes 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 SYSTEM.REPCAT$_RESOL_STATS_CONTROL;

Dependencies

[top of page]

SYSTEM.REPCAT$_RESOL_STATS_CONTROL does not reference any database object

SYSTEM.REPCAT$_RESOL_STATS_CONTROL is referenced by following:

SchemaSYS
ViewALL_REPRESOL_STATS_CONTROL
ViewDBA_REPRESOL_STATS_CONTROL
Package BodyDBMS_REPCAT_CONF - show dependent code
Package BodyDBMS_REPUTIL - show dependent code
ViewUSER_REPRESOL_STATS_CONTROL