SQL> l
1* select sid, serial#, program, username, status from v$session
SID SERIAL# PROGRAM USERNAME STATUS
--------- --------- ------------------------------ ------------ --------
116 2733 MSACCESS.EXE LOSHERRYM INACTIVE
118 1088 MSACCESS.EXE LOKIML INACTIVE
119 2271 sqlload_at_excelsior (TNS V1-V2) CALLREC ACTIVE
120 7432 MSACCESS.EXE LOPATRICIM SNIPED
121 1831 MSACCESS.EXE LOGILLIANC SNIPED
122 1973 MSACCESS.EXE LOKARLETTH INACTIVE
123 3281 MSACCESS.EXE LOCLAUDIAH INACTIVE
124 1963 MSACCESS.EXE LOGERALDIG INACTIVE
125 5183 MSACCESS.EXE LOKIMBERLB INACTIVE
126 1701 MSACCESS.EXE LOTRACEYB INACTIVE
Steven Cardinal wrote in message <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:04:51 CDT
