[Home] [Help] [Dependency Information]
Object Name: | DBA_HIST_ASH_SNAPSHOT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
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) | ||
CON_ID | NUMBER |
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
, CON_ID
FROM SYS.DBA_HIST_ASH_SNAPSHOT;
|
|
|