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

TABLE: SYS.WRM$_WR_CONTROL

Object Details
Object Name: WRM$_WR_CONTROL
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WRM$_WR_CONTROL_PK
  1. ColumnDBID
Indexes
Index Type Uniqueness Tablespace Column
WRM$_WR_CONTROL_PK NORMAL UNIQUE TablespaceSYSAUX ColumnDBID
Columns
Name Datatype Length Mandatory Comments
DBID NUMBER
Yes
SNAP_INTERVAL INTERVAL DAY(5) TO SECOND(1) (11) Yes
SNAPINT_NUM NUMBER

RETENTION INTERVAL DAY(5) TO SECOND(1) (11) Yes
RETENTION_NUM NUMBER

MOST_RECENT_SNAP_ID NUMBER
Yes
MOST_RECENT_SNAP_TIME TIMESTAMP(3) (11)
MRCT_SNAP_TIME_NUM NUMBER

STATUS_FLAG NUMBER

MOST_RECENT_PURGE_TIME TIMESTAMP(3) (11)
MRCT_PURGE_TIME_NUM NUMBER

MOST_RECENT_SPLIT_ID NUMBER

MOST_RECENT_SPLIT_TIME NUMBER

SWRF_VERSION NUMBER

REGISTRATION_STATUS NUMBER

MRCT_BASELINE_ID NUMBER

TOPNSQL NUMBER

MRCT_BLTMPL_ID NUMBER

SRC_DBID NUMBER

SRC_DBNAME VARCHAR2 (32)
T2S_DBLINK VARCHAR2 (128)
FLUSH_TYPE NUMBER

SNAP_ALIGN NUMBER

Query Text

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


SELECT DBID
,      SNAP_INTERVAL
,      SNAPINT_NUM
,      RETENTION
,      RETENTION_NUM
,      MOST_RECENT_SNAP_ID
,      MOST_RECENT_SNAP_TIME
,      MRCT_SNAP_TIME_NUM
,      STATUS_FLAG
,      MOST_RECENT_PURGE_TIME
,      MRCT_PURGE_TIME_NUM
,      MOST_RECENT_SPLIT_ID
,      MOST_RECENT_SPLIT_TIME
,      SWRF_VERSION
,      REGISTRATION_STATUS
,      MRCT_BASELINE_ID
,      TOPNSQL
,      MRCT_BLTMPL_ID
,      SRC_DBID
,      SRC_DBNAME
,      T2S_DBLINK
,      FLUSH_TYPE
,      SNAP_ALIGN
FROM SYS.WRM$_WR_CONTROL;

Dependencies

[top of page]

SYS.WRM$_WR_CONTROL does not reference any database object

SYS.WRM$_WR_CONTROL is referenced by following:

SchemaSYS
Package BodyDBMS_SWRF_INTERNAL - show dependent code
ViewINT$DBA_HIST_WR_CONTROL