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

From: <manoj67_at_hotmail.com>
Date: 1998/03/31
Message-ID: <6frubj$iu9$1@nnrp1.dejanews.com>#1/1

Hi Steve,

You may try following query for the current connected user.

select SID, SERIAL#, USERNAME, STATUS
v$session where audsid = userenv('sessionid')

Hope this helps,

Manoj Jain
Oracle DBA

In article <01bd5bfa$57135bc0$4553a4a7_at_w00128433>, "Highmark Blue Cross Blue Shield" <sdancisin_at_highmark.com> 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.
>
> --
> Steve Dancisin
> Oracle Database Administrator
> Highmark Blue Cross Blue Shield
> sdancisin_junk_at_highmark.com
> (Removed _junk from my address before answering this message.)
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 31 1998 - 00:00:00 CST