Hi, Lionnel!

SELECT p.spid "SERVER_PID", s.process "CLIENT_PID"
FROM v$session s, v$process p
WHERE s.username = UPPER( '&username' )
AND p.addr = s.paddr;

Cheers / Jocke Treugut

www.treugut-tuning.com


--- Vinod Gopinath BMMI IS
<[Email Address Removed] skrev: > Select SERIAL#,
USERNAME, OSUSER, MACHINE, TERMINAL
> From v$session;
>
> /- Vin
>
> -----Original Message-----
> From: Lionnel Rey [mailto:lionel.[Email Address Removed]
> Sent: Wednesday, April 21, 2004 12:05 PM
> To: LazyDBA.com Discussion
> Subject: process id identification
>
>
> Hello,
>
> How can I find the process id of my session when
> several users using the
> same username are connected ?
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here:
> http://tahiti.oracle.com
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here:
> http://tahiti.oracle.com
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>

Höstrusk och grå moln - köp en resa till solen på Yahoo! Resor på adressen http://se.docs.yahoo.com/travel/index.html
Oracle LazyDBA home page