SNAP_ID

NUMBER

NOT NULL

Unique snapshot ID

DBID

NUMBER

NOT NULL

Database ID for the snapshot

INSTANCE_NUMBER

NUMBER

NOT NULL

Instance number for the snapshot

STARTUP_TIME

TIMESTAMP(3)

NOT NULL

Startup time of the instance

BEGIN_INTERVAL_TIME

TIMESTAMP(3)

NOT NULL

Time at the beginning of the snapshot interval

END_INTERVAL_TIME

TIMESTAMP(3)

NOT NULL

Time at the end of the snapshot interval; the actual time the snapshot was taken

FLUSH_ELAPSED

INTERVAL DAY(5) TO SECOND(1)

Amount of time to perform the snapshot

SNAP_LEVEL

NUMBER

Snapshot level

STATUS

NUMBER

Indicates if the snapshot was successfully flushed without any errors. Possible values:

• 0 – No errors

• 1 – Errors on some AWR tables

ERROR_COUNT

NUMBER

Number of errors occurring in the tables for the particular snapshot

BL_MOVED

NUMBER

Reserved for internal use

SNAP_FLAG

NUMBER

Condition under which the snapshot was inserted. Possible values are:

• 1 – Manual snapshot created using a PL/SQL package

• 2 – Imported snapshot

• 4 – Snapshot taken while Diagnostic Pack or Tuning Pack was not enabled

SNAP_TIMEZONE

INTERVAL DAY(0) TO SECOND(0)

Snapshot time zone expressed as offset from UTC (Coordinated Universal Time) time zone

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

• 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

• 1: This value is used for rows containing data that pertain to only the root

• n: Where n is the applicable container ID for the rows containing data