Re: monitor user processes

Take these steps:

1. Identify the session which you want to monitor (V$SESSION). Learn its SID.
2. Select statistics for your session from V$SESSTAT.
3. Select statistics for your session from V$SESSTAT again.
4. Compare the results, filtering out what you want (CPU, io or whatever you find interesting). Access a statistic by name in V$STATNAME.

Regards,
Karen Abgarian.

Steven Cardinal wrote:

> 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
> >
> > 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:52:04 CDT