UNIX Process to SID and SERIAL#

From: Norman Dunbar <ndunbar_at_lynxfinancialsystems.co.uk>
Date: Fri, 15 Jun 2001 09:18:30 +0100
Message-ID: <F43E6BAE5BB5D411A44C00805FBE740DA150F5@apps.leeds.lfs.co.uk>

Try select * from v$session where process='pid'; and pid is the rogue process id from a ps on the unix box.

Regards,
Norman.

-----Original Message-----
From: d [mailto:d_at_d.com]
Posted At: Friday, June 15, 2001 6:11 AM Posted To: server
Conversation: UNIX Process to SID and SERIAL# Subject: UNIX Process to SID and SERIAL#

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. Received on Fri Jun 15 2001 - 03:18:30 CDT