[Home] [Help] [Dependency Information]
Object Name: | CDB_HIST_SNAPSHOT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Snapshot Information in all containers
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 | |||
ERROR_COUNT | NUMBER | |||
SNAP_FLAG | NUMBER | |||
SNAP_TIMEZONE | INTERVAL DAY(0) TO SECOND(0) | (11) | ||
CON_ID | NUMBER | container id |
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
, ERROR_COUNT
, SNAP_FLAG
, SNAP_TIMEZONE
, CON_ID
FROM SYS.CDB_HIST_SNAPSHOT;
SYS.CDB_HIST_SNAPSHOT does not reference any database object
SYS.CDB_HIST_SNAPSHOT is referenced by following:
|
|
|