Automatic Workload Repository Views :
Historical data (snapshot) stored in AWR can be seen using the following views:
- V$ACTIVE_SESSION_HISTORY – Displays the active session history (ASH) sampled every second.
- V$METRIC – Displays metric information.
- V$METRICNAME – Displays the metrics associated with each metric group.
- V$METRIC_HISTORY – Displays historical metrics.
- V$METRICGROUP – Displays all metrics groups.
- DBA_HIST_ACTIVE_SESS_HISTORY – Displays the history of the contents of the in-memory active session history for recent system activity.
- DBA_HIST_BASELINE – Displays baseline information.
- DBA_HIST_DATABASE_INSTANCE – Displays database environment information.
- DBA_HIST_DB_CACHE_ADVICE displays historical predictions of the number of physical reads for the cache size corresponding to each row.
- DBA_HIST_DISPATCHER displays historical information for each dispatcher process at the time of the snapshot.
- DBA_HIST_SNAPSHOT – Displays snapshot information.
- DBA_HIST_WR_CONTROL – Displays AWR settings.
- DBA_HIST_DYN_REMASTER_STATS Displays statistical information about the dynamic remastering process.
- DBA_HIST_IOSTAT_DETAIL Displays historical I/O statistics aggregated by file type and function.
- DBA_HIST_SHARED_SERVER_SUMMARY Displays historical information for shared servers, such as shared server activity, common queues and dispatcher queues.
- DBA_HIST_SQL_PLAN – Displays SQL execution plans.
Thank you for reading …..This is Airy…Enjoy 🙂
It’s good