Re: awr history

  • From: "ed lewis" <eglewis71@xxxxxxxxx>
  • To: "Kellyn Pedersen" <kjped1313@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 13 Jan 2011 05:28:45 -0500

    Thanks very much for your response.
I will look at these. 

    thanks again


  ----- Original Message ----- 
  From: Kellyn Pedersen 
  To: eglewis71@xxxxxxxxx ; oracle-l@xxxxxxxxxxxxx 
  Sent: Wednesday, January 12, 2011 11:14 PM
  Subject: Re: awr history

  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

  Kellyn Pedersen

  Sr. Database Administrator

  From: ed lewis <eglewis71@xxxxxxxxx>
  To: oracle-l@xxxxxxxxxxxxx
  Sent: Wed, January 12, 2011 6:21:01 PM
  Subject: awr history

      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.


Other related posts: