Re: Interesting problem

From: dbvision@xxxxxxxxxxxx
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 27 May 2005 16:39:13 +0800

Quoting David Turner <dnt9000@xxxxxxxxx>:

> 
> I've set up a script that montors the db every minute
> but it just doesn't appear to be catching what is
> causing our normally fast running queries to
> periodically run long. If any of you have any
> suggestions on diagnosing this I'd appreciate it.
> 
> The main areas I've focused on are
> 
> A minute by minute report of v$session and v$process
> info

Maybe v$session is the wrong view?  v$sql, columns CPU_TIME 
and ELAPSED_TIME spring to mind as better chances at
catching the offender?  Followed by snapshot stats for
that session?

Cheers
Nuno Souto
from sunny (but cold) Sydney, Australia

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: Interesting problem
From: Mladen Gogala

References:
- Interesting problem
  - From: David Turner

Re: Interesting problem

Other related posts: