4.292 DBA_HIST_ASH_SNAPSHOT
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 |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Startup time of the instance |
|
|
|
Time at the beginning of the snapshot interval |
|
|
|
Time at the end of the snapshot interval; the actual time the snapshot was taken |
|
|
|
Amount of time to perform the snapshot |
|
|
|
Snapshot level |
|
|
|
Indicates if the snapshot was successfully flushed without any errors. Possible values:
|
|
|
|
Number of errors occurring in the tables for the particular snapshot |
|
|
|
Reserved for internal use |
|
|
|
Condition under which the snapshot was inserted. Possible values are:
|
|
|
|
Snapshot time zone expressed as offset from UTC (Coordinated Universal Time) time zone |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: