AWR related data dictionary views
V$ACTIVE_SESSION_HISTORY
This view displays active database session activity, sampled once every second.
V$metric
This view provides metric data to track the performance of the system
V$METRICGROUP
The metric views are organized into various groups, such as event, event class, system, session, service, file, and tablespace metrics.
DBA_HIST_ACTIVE_SESS_HISTORY
displays the history of sessions for recent system activity
DBA_HIST_BASELINE
Shows base line type and time range
DBA_HIST_BASELINE_DETAILS
Shows a detail about a particular baseline
DBA_HIST_BASELINE_TEMPLATE
Gives base line template information used to generate baselines
DBA_HIST_DATABASE_INSTANCE
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
No comments:
Post a Comment