Manually run AWR report
Here's a great resource for running Oracle's AWR report manually from the SQL prompt.
http://oraclefunda.wordpress.com/2009/10/29/how-to-create-awr-report-manually/
http://oraclefunda.wordpress.com/2009/10/29/how-to-create-awr-report-manually/
Comments