Tuesday, April 17, 2012

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

        Further reading

        AWR report scenarios


        How to read AWR reports


        Modifying AWR Statistics Interval and Retention Periods

        Finding Problematic SQL and Top waits from past using AWR tables

        No comments:

        Post a Comment