• 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

select_workload_repository from all users