Get SessionID

SELECT sid FROM v$mystat WHERE rownum = 1;

SELECT sid FROM V$SESSION WHERE audsid = userenv('sessionid');

SELECT sid FROM V$SESSION WHERE audsid = SYS_CONTEXT('userenv','sessionid');

select sys_context('USERENV','SID') from dual;