Re: Script to automate AWR reports (not snapshots)

From: Ujang Jaenudin <>
Date: Thu, 11 Mar 2010 12:32:04 +0700
Message-ID: <>


I've written the same for simplicity....just pass parameters of numofdays, tns, user, awr location
look at

On 3/5/10, Sandra Becker <> 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

Received on Wed Mar 10 2010 - 23:32:04 CST

Original text of this message