Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub


DBA_HIST_ASH_SNAPSHOT provides the list of snapshots that contains Active Session History (ASH) data. This view differs from DBA_HIST_SNAPSHOT in that it provides snapshots which had errors flushing some Automatic Workload Repository (AWR) tables, but for which ASH data may be successfully flushed (DBA_HIST_SNAPSHOT filters out snapshots which had errors flushing AWR tables).

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
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