Re: awr history

From: ed lewis <eglewis71_at_gmail.com>
Date: Thu, 13 Jan 2011 05:28:45 -0500
Message-ID: <BF6EFE6161624071A1483D73A8D81EDE_at_CATHY>

Kellyn,

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

    thanks again

        ed

• Original Message ----- From: Kellyn Pedersen To: eglewis71_at_gmail.com ; oracle-l_at_freelists.org 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   http://karlarao.wordpress.com/scripts-resources/    

  Kellyn Pedersen

  Sr. Database Administrator

  http://www.linkedin.com/in/kellynpedersen

  www.dbakevlar.com

---

  From: ed lewis <eglewis71_at_gmail.com>   To: oracle-l_at_freelists.org
  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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 13 2011 - 04:28:45 CST