Re: monitor user processes

steve,
assuming there are no locks or resources that the session is waiting on, i have always looked at v$sess_io to see if it is doing anything.

james koopmann
jkoopmann_at_servman.com
www.servman.com

Steven Cardinal <scardinal_at_yahoo.com> wrote in message news:7sb4sq$men_at_chronicle.concentric.net...
> What's the easiest way to monitor a user process to see if it is still
> performing work? Sometimes a process takes longer than expected, and we
are
> unsure if it is hung, or just working slowly. MS-SQL has a stored
procedure
> called sp_who2 that will show me cpu and io usage - if we run this
multiple
> times and those number get larger we know things are still moving - how do
I
> get the same kind of info out of 8.0.4 or 8.0.5 ?
>
> Thanks
> Steve
>
>
Received on Wed Sep 22 1999 - 13:25:29 CDT