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)