Re: monitor user processes

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 22 Sep 1999 19:14:21 +0100
Message-ID: <938024116.10624.1.nnrp-14.9e984b29@news.demon.co.uk>

Better bet is to look at v$sess_io then.

Physical reads is a close machine for I/O, the other gets are a reasonably guide to CPU

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Steven Cardinal wrote in message <7sb6fq$ngb_at_chronicle.concentric.net>...
>Is there anything that would also show io or cpu - I guess I don't trust
>that just because the process is active, that it's still chugging along
>(although maybe my experience with MS-SQL has me pessimistic - there, i
>would see an active state even though the job has hit a wall)
>
>Thanks
>Steve
>
>Jeff Hunter wrote in message <37e91a83_at_defiant.btitelecom.net>...
>>SQL> l
>> 1* select sid, serial#, program, username, status from v$session
>>
Received on Wed Sep 22 1999 - 13:14:21 CDT