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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
