AWR快速入门
http://blog.csdn.net/netbios333/archive/2009/06/12/4264114.aspx

ORACLE10G AWR使用和分析
http://space.itpub.net/12778571/viewspace-606593

ORACLE-BASE - Oracle DBA and development articles, scripts, HOWTOs and forums (8i, 9i, 10g, 11g)
http://www.oracle-base.com/articles/11g/Articles11g.php

Oracle Database 11g：性能优化

http://wenku.baidu.com/view/431c3aaad1f34693daef3ef7.html

补充：

Oracle 10g/11g AWR/STATSPACK，

在10g/11g同时开启AWR/STATSPACK功能时，发现AWR不能定时收集信息，只好用cron job代之，

crontab -l

# run awr/stats pack
0,10,20,30,40,50   * * * * /home/oracle/utility/statspack.sh 10 >> /home/oracle/utility/log/statspack10_10.log 2>&1
0,10,20,30,40,50   * * * * /home/oracle/utility/runAWR.sh 10 >> /home/oracle/utility/log/runAWR_10.log 2>&1

col snap_interval format a20
col retention format a20
select * from dba_hist_wr_control;

      DBID SNAP_INTERVAL        RETENTION            TOPNSQL
---------- -------------------- -------------------- --------------------
3258538501 +00000 00:10:00.0    +00030 00:00:00.0    DEFAULT

--10 分钟间隔，保留30天
exec dbms_workload_repository.modify_snapshot_settings(interval=>10, retention=>30*24*60);