• How to select statements from AWR? (Upgrade your Database - NOW!)
  How to pick SQL statements out of AWR to create a workload for DBMS_Advisor runs
  in Oracle > Optimization with 11g access advisor awr basic_filter dbms_advisor dbms_sqltune filter plsql select_workload_repository sql sqlaccess tuning workload
• Kerry Osborne Oracle Blog Blog Archive Unstable Plans (Oracle Plan Stability/Instability) – Kerry Osborne’s Oracle Blog
  unstable plans what changed oracle execution awr snapshot
  in Oracle > Optimization with awr change plan
• Kerry Osborne’s Oracle Blog » Blog Archive » Tracking Parameter Changes – Kerry Osborne’s Oracle Blog
  tracking changes, retain AWR history
  in Oracle > Optimization with awr repository retention workload
• Kerry Osborne’s Oracle Blog » Blog Archive » What Did My New Index Mess Up? – Kerry Osborne’s Oracle Blog
  find significantly different average elapsed times per execution. It uses AWR data and computes a normalized standard deviation between the average elapsed time per execution before and after the date specified by the days_ago parameter
  in Oracle > DB 11g with 11g analysis awr changed index oracle performance snap snap_id sql_id statistics whats
• Oracle
  Find unused Indexes by querying AWR
  in Oracle > DB 11g with awr hist history indexes snapshot sql sql_plan sqlstat statspack unused
• Oracle 11g R2 Performance Tuning -AWR
  Descriptive information in AWR 11g special scripts Automatic Workload Repository Report awrrpt.sql Automatic Database Diagnostics Monitor Report addmrpt.sql ASH Report ashrpt.sql AWR Diff Periods Report awrddrpt.sql AWR Single SQL Statement Report awrsqrpt.sql AWR Global Report awrgrpt.sql AWR Global Diff Report awrgdrpt.sql
  in Oracle > Optimization with 11g automatic awr awrrpt.sql diagnostics optimization oracle report reports repository scripts sql workload

awr from all users