5.58 DBA_HIST_SNAPSHOT
DBA_HIST_SNAPSHOT
displays information about the snapshots in the Workload Repository.
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 |
|
|
|
Number of errors occurring in the tables for the particular snapshot |
|
|
|
Condition under which the snapshot was inserted. Possible values are:
|
|
|
|
Snapshot time zone expressed as offset from UTC (Coordinated Universal Time) time zone |
|
|
|
Time at the beginning of the snapshot interval, with timezone |
|
|
|
Time at the end of the snapshot interval; the actual time the snapshot was taken, with timezone |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
Table F-1 for more information about the MMON
process