Assuming you have it set up, you could use Statspack as well. On Mon, Oct 7, 2013 at 8:25 AM, Storey, Robert (DCSO) < RStorey@xxxxxxxxxxxxxxxxxx> wrote: > Probably been asked a few times, so I'll throw it out there again. > Its Monday morning and our support team tells you that the database seems > to go up and down several times during a 30 minute period on Saturday > night. Users were complaining of using the application and getting the > dreaded spinning hour glass. But, a check of the alert.log and other > Windows logs shows no errors, no trace files, and no downtime on the > database. > > What's your preferred tool for after-the-fact diagnosis of the issue? > This is on a 9i system but I don't have it hooked into grid or cloud > control. > > Foglight from Toad? AWR reports (assuming you were in Grid or Cloud)? > Other good tool? > > -- > //www.freelists.org/webpage/oracle-l > > > -- A life yet to be lived... -- //www.freelists.org/webpage/oracle-l