Use SYS_CONTEXT to Obtain Session Information

select sid from v$session where audsid=sys_context('userenv','SESSIONID');