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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Who am I in v$session view???

Re: Who am I in v$session view???

From: Frank <franjoe_at_frisurf.no>
Date: Tue, 13 Mar 2001 19:58:17 +0100
Message-ID: <N9ur6.2549$NY6.48173@news3.oke.nextra.no>

Hi!
"Me" have the sessionid from the query below, if it is run in "me"'s session

 select userenv('SESSIONID')
 from dual;

Join this number with AUDSID in v$session.

Frank Received on Tue Mar 13 2001 - 12:58:17 CST

Original text of this message

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