Aldi,
The (free) oraproc.ksh script on the oriolecorp.com site just does
that (if you are not under Unix, find the Korn shell for NT :)). It
crosses the output of 'ps' with the contents of v$session and can
display the SQL statement being executed together with CPU and memory
consumption. It's a 'snapshot' tool, but it's quite handy when the
server is beginning to breathe heavily.
--
Regards,
Stephane Faroult
email: sfaroult_at_oriolecorp.com
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax: +44 (0) 7050-696-449
Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------
>
> Hi list..
>
> Users have just complained about dropped performance, more than 10 times
> slower. This was due to one user was running a long-run job i.e importing a
> big table.
>
> Is there a way to know who is currently running a long-run job ?
> Can we know how much resource (percentage of cpu, mem, etc) is being
> allocated for each user ?
>
> Tia for any clue.
Received on Tue May 23 2000 - 04:08:29 CDT
