To get the info of your session you can use the SYS_CONTEXT function with USERENV namespace.
usage of SYS_CONTEXT is like ;
SYS_CONTEXT(‘namespace’, ‘parameter’ [, length ])
The context namespace must already have been created, and the associated parameter and its value must also have been set using the DBMS_SESSION.set_context procedure. The parameter is not case sensitive. (Refer to the manual for context creation)
There are examples from the usage of sys_context with userenv namespace
references: Oracle® Database SQL Quick Reference10g Release 1 (10.1)
Thanks That was helpful
There are 2 ways of getting Session info from Oracle
SELECT SYS_CONTEXT(‘USERENV’,'SESSIONID’) from DUAL;
select userenv(‘SESSIONID’) from dual;
Comment by satishmc — December 30, 2010 @ 12:56 pm