Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UNIX Process to SID and SERIAL#
"d" <d_at_d.com> wrote in message news:<vNgW6.94252$%i7.68132217_at_news1.rdc1.sfba.home.com>...
> Hi Oracle Experts,
>
> Is there a way to trace a unix process id to a SID and SERIAL#? There's a
> dedicated server process that is taking 99% of CPU and I want to know what
> session that process is assocated with. I am not using MTS.
sure
select s.sid, s.serial#
from v$process p, v$session s
where s.paddr = p.addr
and p.spid = <unix process id>
Hth,
Sybrand Bakker, Oracle DBA Received on Fri Jun 15 2001 - 03:53:18 CDT