Karl must have missed this email, but I'll promote his scripts for him... I've had way too much fun with them not to! :) The AWR gen script, (awr_genwl.sql) was a source of great fun, that only after a few, minor tweaks and a table creation, I was retaining high level AWR data by dbid in a repository. How nice it was to create many pretty, colorful graphs for non-technical managers when they were quick to say, "It was the databases fault!" :D http://karlarao.wordpress.com/scripts-resources/ Kellyn Pedersen Sr. Database Administrator http://www.linkedin.com/in/kellynpedersen www.dbakevlar.com ________________________________ From: ed lewis <eglewis71@xxxxxxxxx> To: oracle-l@xxxxxxxxxxxxx Sent: Wed, January 12, 2011 6:21:01 PM Subject: awr history Hello, I'm looking for a way to query the AWR, and ASH tables to create customized reports. I would also like to present some of the results in graphs. Can anyone recommend any sources for this ? Scripts, websites, or 3rd party tools. Thanks in advance. Ed