oraclePerformance TuningScripts

Snapshot Workload Repository & Retention

Snapshot Workload Repository & Retention DBA_HIST_SNAPSHOT displays information about the snapshots in the Workload Repository. It results Snapshots for each instance Time at the beginning of the snapshot interval, Time at the end of the snapshot interval, Startup time of the instance, Snapshot level, Number of errors occurring in the tables for the particular snapshots.