Uploading the scripts used in this blog post:
http://www.pythian.com/blog/do-awr-reports-show-the-whole-picture