From: "Hui, Kwok Miu" <huikomix@dt.com.hk>
Subject: Re: How do I get my session ID
Date: 1996/11/26
Message-ID: <329BA45B.50A2@dt.com.hk>#1/1
references: <32948425.1215@tomax.com>
to: fredb@tomax.com
content-type: text/plain; charset=us-ascii
organization: Cho Yang (Hong Kong) Co., Ltd.
mime-version: 1.0
reply-to: huikomix@dt.com.hk
newsgroups: comp.databases.oracle
x-mailer: Mozilla 3.01 (Win16; I)



Fred Blindheim wrote:
> 
> I can type the following:
> 
>   SELECT osuser, sid
>     FROM v$session
> 
> and get a list of all the current Oracle users and their session id.
> But, how to can I return just MY session id.  Can Oracle tell me what my
> osuser is so I can stick it in the where clause?  

Try this:

 SELECT osuser, sid
     FROM v$session
     WHERE username=user;
-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix@dt.com.hk
Oracle DBA & Unix Administrator      Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049