DBA_HIST_SNAPSHOT displays information about the snapshots in the Workload Repository.

Column Datatype NULL Description
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
ERROR_COUNT NUMBER   Number of errors occurring in the tables for the particular snapshot
SNAP_FLAG NUMBER   Condition under which the snapshot was inserted. Possible values are:

0 - Snapshot was taken automatically by the Manageability Monitor Process (MMON process)

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_TIMEZONEFoot 1  INTERVAL DAY(0) TO SECOND(0)   Snapshot time zone expressed as offset from UTC (Coordinated Universal Time) time zone

Footnote 1 This column is available starting with Oracle Database 11g Release 2 (

See Also:

Table F-1 for more information about the MMON process