Re: Script to automate AWR reports (not snapshots)
- From: Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx>
- To: sbecker6925@xxxxxxxxx
- Date: Thu, 11 Mar 2010 12:32:04 +0700
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@xxxxxxxxx> 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
Other related posts:
