Re: Interesting problem

Quoting David Turner <dnt9000_at_yahoo.com>:

>
> 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