Re: How do I get my session ID

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_at_dt.com.hk
Oracle DBA & Unix Administrator      Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049