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

VIEW: SYS.INT$DBA_HIST_ASH_SNAPSHOT

Object Details
Object Name: INT$DBA_HIST_ASH_SNAPSHOT
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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.INT$DBA_HIST_ASH_SNAPSHOT;

Dependencies

[top of page]

SYS.INT$DBA_HIST_ASH_SNAPSHOT references the following:

SchemaSYS
TableWRM$_SNAPSHOT
TableWRM$_SNAP_ERROR
SYS.INT$DBA_HIST_ASH_SNAPSHOT is referenced by following:

SchemaSYS
ViewDBA_HIST_ASH_SNAPSHOT