Automatic Workload Repository Views

Typically, you would view the AWR data through Oracle Enterprise Manager screens
or AWR reports. However, you can view the statistics with the following views:
■ V$ACTIVE_SESSION_HISTORY
This view displays active database session activity, sampled once every second.
■ V$ metric views provide metric data to track the performance of the system
The metric views are organized into various groups, such as event, event class,
system, session, service, file, and tablespace metrics. These groups are identified in
the V$METRICGROUP view.

■ DBA_HIST views
The DBA_HIST views contain historical data stored in the database. This group of
views includes:
■ 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
■ DBA_HIST_DATABASE_INSTANCE displays information about the database
environment
■ 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.

[@more@]