• How to “MAX” out your Fast Refresh Materialized Views - Blue Gecko
  DBMS_ADVISOR.TUNE_MVIEW,
  in Oracle > DB 11g with dbms_advisor materialized max mv tune tune_mview view views
• 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

dbms_advisor from all users