Re: Net connection and processes

In article <m0r727L-000BivC_at_jabber> chris_at_perihelion.co.uk (chris) writes:
> I use a tool called lsof to help identify what Un*x processes are
> associated with what Oracle sessions.
>
> It is available in the public domain (I can't remember where from - but
> an archie should help you out).
>
> It runs on most versions of Un*x.
>
> BTW :- It also helps identify those annoying processes that prevent you
> from dismounting a filing system.
>
> Chris Selwyn
> Senior Consultant
> Perihelion Software
> email: chris_at_perihelion.co.uk
> tel: +44 749 344203

The Oracle UNIX PID related to a Client Connection is:

select SPID from v$process

	where ADDR = (select PADDR from v$session 
		where AUDSID = userenv('SESSIONID'))

Stephane Ah-ki
Logibec Groupe Informatique Ltee
Montreal, Canada Received on Fri Nov 18 1994 - 00:19:23 CET