Re: Favorite tool

  • From: Maaz Anjum <maazanjum@xxxxxxxxx>
  • To: RStorey@xxxxxxxxxxxxxxxxxx
  • Date: Mon, 7 Oct 2013 08:54:57 -0400

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


Other related posts: