Re: Favorite tool

From: Maaz Anjum <>
Date: Mon, 7 Oct 2013 08:54:57 -0400
Message-ID: <>

Assuming you have it set up, you could use Statspack as well.

On Mon, Oct 7, 2013 at 8:25 AM, Storey, Robert (DCSO) <> 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?
> --

A life yet to be lived...

Received on Mon Oct 07 2013 - 14:54:57 CEST

Original text of this message