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: Retrieve information from v$session for current user.

Re: Retrieve information from v$session for current user.

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1998/03/30
Message-ID: <3525d525.14765191@192.86.155.100>#1/1

A copy of this was sent to "Highmark Blue Cross Blue Shield" <sdancisin_at_highmark.com>
(if that email address didn't require changing) On 30 Mar 1998 16:24:11 GMT, you wrote:

>Does anyone know how can retrieve information from the view V$SESSION table
>for the current connected user. I was thinking
>that I could use the SID and Serial # as parameters, but I am not sure how
>I can get these.
>
>Any help would be appreciated.

select * from v$session
where audsid = userenv('sessionid')

will get it.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Mar 30 1998 - 00:00:00 CST

Original text of this message

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