Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What's my session's pid?

Re: What's my session's pid?

From: Bart the bear <bartthebear_at_gmail.com>
Date: 16 Aug 2005 13:30:48 -0700
Message-ID: <1124224248.683775.175190@g44g2000cwa.googlegroups.com>


select spid from v$process
where addr in (

       select paddr from v$session 
      where sid=dbms_support.mysid)
Received on Tue Aug 16 2005 - 15:30:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US