Re: Script to automate AWR reports (not snapshots)

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Thu, 11 Mar 2010 12:32:04 +0700
Message-ID: <3edcb66e1003102132t6b54f78dhcafa4959c1fd079_at_mail.gmail.com>



sandy,

I've written the same for simplicity....just pass parameters of numofdays, tns, user, awr location
look at http://blog.dbs247.com/?p=29

On 3/5/10, Sandra Becker <sbecker6925_at_gmail.com> wrote:
>
> Thanks everyone. Looks like Tim's script will do what I want. I did go
> back and get dates and times of the performance problems. Management was
> off every time so they were not asking for the correct snapshots. They
> insisted I get them anyway. I will be doing reports the ACTUAL periods we
> had problems and making my decisiions based on those reports. They did
> finally fix a critical lookup table I'd been complaining about for about 2
> years now and our worst problems mysteriously vanished. We still have other
> problems but I think we have enough head room now to do it right the first
> time when we fix the problematic sql statements.
>
> Sandy
>
>
>

-- 
thanks and regards
ujang | oracle dba | mysql dba
jakarta - indonesia

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 10 2010 - 23:32:04 CST

Original text of this message