[Home] [Help] [Dependency Information]
Object Name: | WRM$_SNAPSHOT |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WRM$_SNAPSHOT_PK | NORMAL | UNIQUE | SYSAUX |
DBID
SNAP_ID INSTANCE_NUMBER |
Table | |
Foreign Table | Foreign Key Column | WRM$_SNAPSHOT | WRM$_DATABASE_INSTANCE |
WRM$_SNAPSHOT
DBID
WRM$_SNAPSHOT INSTANCE_NUMBER WRM$_SNAPSHOT STARTUP_TIME |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAP_ID | NUMBER | Yes | ||
DBID | NUMBER | Yes | ||
INSTANCE_NUMBER | NUMBER | Yes | ||
STARTUP_TIME | TIMESTAMP(3) | (11) | Yes | |
BEGIN_INTERVAL_TIME | TIMESTAMP(3) | (11) | Yes | |
END_INTERVAL_TIME | TIMESTAMP(3) | (11) | Yes | |
FLUSH_ELAPSED | INTERVAL DAY(5) TO SECOND(1) | (11) | ||
SNAP_LEVEL | NUMBER | |||
STATUS | NUMBER | |||
ERROR_COUNT | NUMBER | |||
BL_MOVED | NUMBER | |||
SNAP_FLAG | NUMBER | |||
SNAP_TIMEZONE | INTERVAL DAY(0) TO SECOND(0) | (11) |
Cut, paste (and edit) the following text to query this object:
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, STARTUP_TIME
, BEGIN_INTERVAL_TIME
, END_INTERVAL_TIME
, FLUSH_ELAPSED
, SNAP_LEVEL
, STATUS
, ERROR_COUNT
, BL_MOVED
, SNAP_FLAG
, SNAP_TIMEZONE
FROM SYS.WRM$_SNAPSHOT;
SYS.WRM$_SNAPSHOT does not reference any database object
SYS.WRM$_SNAPSHOT is referenced by following:
|
|
|