awr views

Oracle AWR 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 contents of the active session history.
    DBA_HIST_BASELINE - Displays baseline information.
    DBA_HIST_DATABASE_INSTANCE - Displays database environment information.
    DBA_HIST_SNAPSHOT - Displays snapshot information.
    DBA_HIST_SQL_PLAN - Displays SQL execution plans.
    DBA_HIST_WR_CONTROL - Displays AWR settings.


select * 
from   dba_hist_sqlstat t, dba_hist_snapshot s
where  t.snap_id = s.snap_id
and    t.dbid = s.dbid
and    t.instance_number = s.instance_number
and    s.begin_interval_time between trunc(sysdate)-1 and trunc(sysdate)