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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Getting my Oracle SID

Re: Getting my Oracle SID

From: Arnaud Bauer <arnaud.bauer_at_jii.fr>
Date: Thu, 19 Nov 1998 11:34:46 +0100
Message-ID: <3653F446.6C6FD3A3@jii.fr>


OK i found something

select sid from v$session where AUDSID=(select userenv('SESSIONID') from dual);

it returns the correct SID of my connection.


Received on Thu Nov 19 1998 - 04:34:46 CST

Original text of this message

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