Using Automatic Workload Repository Views

Typically, you would view AWR data using Oracle Enterprise Manager Cloud Control (Cloud Control) or AWR reports. However, you can also view historical data stored in the AWR using the following DBA_HIST views.

Table 6-1 DBA_HIST Views

DBA_HIST View	Description
`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 information about the baselines captured on the system, such as the time range of each baseline and the baseline type.
`DBA_HIST_BASELINE_DETAILS`	Displays details about a specific baseline.
`DBA_HIST_BASELINE_TEMPLATE`	Displays information about the baseline templates used by the system to generate baselines.
`DBA_HIST_CON_SYS_TIME_MODEL`	Displays historical system time model statistics, including OLAP timed statistics.
`DBA_HIST_CON_SYSMETRIC_HIST`	Displays the historical information about the system metric values.
`DBA_HIST_CON_SYSMETRIC_SUMM`	Displays history of the statistical summary of all the metric values in the system metrics for the long duration (60 seconds) group.
`DBA_HIST_CON_SYSSTAT`	Displays historical system statistics, including OLAP kernel statistics.
`DBA_HIST_CON_SYSTEM_EVENT`	Displays historical information about the total waits for an event.
`DBA_HIST_DATABASE_INSTANCE`	Displays information about the database environment.
`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_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_RSRC_PDB_METRIC`	Displays historical information about the Resource Manager metrics for pluggable databases (PDBs) for the past one hour.
`DBA_HIST_RSRC_METRIC`	Displays historical information about the Resource Manager metrics for consumer groups for the past one hour.
`DBA_HIST_SHARED_SERVER_SUMMARY`	Displays historical information for shared servers, such as shared server activity, common queues and dispatcher queues.
`DBA_HIST_SNAPSHOT`	Displays information on snapshots in the system.
`DBA_HIST_SQL_PLAN`	Displays the SQL execution plans.
`DBA_HIST_WR_CONTROL`	Displays the settings for controlling AWR.
`DBA_HIST_WR_SETTINGS`	Displays the settings and metadata of the AWR.
`DBA_HIST_PROCESS_WAITTIME`	Displays CPU and wait time for a process type.

Note:

In a multitenant environment, these DBA_HIST views can also be interchanged with the AWR_ROOT views and AWR_PDB views at the CDB level and the PDB level respectively.

For example, you can use the AWR_PDB_ACTIVE_SESS_HISTORY view for retrieving the AWR data about the active session history at the PDB level, which is equivalent to the DBA_HIST_ACTIVE_SESS_HISTORY view in an independent database in a non-multitenant environment. The AWR_PDB views will not show any AWR data, if the PDB level snapshots have not been collected.

Refer to AWR Views for more details.