Re: UNIX Process to SID and SERIAL#

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 15 Jun 2001 01:53:18 -0700
Message-ID: <a20d28ee.0106150053.4fa171d1@posting.google.com>

"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