my seesion id, username etc

[PSoni]

hi all


i am using win2k/oracle 8i

when i connect to oracle i want to know my sessionid etc.
i don't want to use
terminal=?
osuser = ? etc.




by

[SANJAY_G]

select userenv('sessionid') from dual;

or

select sys_context('userenv','sessionid') from dual;

[pravin]

there is a table called v$session

u can give like this

select sid,serial#,username,machine,terminal from v$session where username='Ur username';

u will get ur session id details.

[SANJAY_G]

Originally posted by pravin
there is a table called v$session

u can give like this

select sid,serial#,username,machine,terminal from v$session where username='Ur username';

u will get ur session id details.

What if there are multiple sessions for same username??

[shashikumar]

if multiple sessions are connected from same username then the sid and serial# various.

[SANJAY_G]

Originally posted by shashikumar
if multiple sessions are connected from same username then the sid and serial# various.

True. But read the original question again.

[sysdba]

If you only need sid, I use:
select sid from V$mystat where rownum =1;

[guru_heaven]

Originally posted by sysdba
If you only need sid, I use:
select sid from V$mystat where rownum =1;

that if you have the privilege which by default you dont