How to find current session ID

How to find current session ID




Way1: select sid from v$session where sid=(select sid from v$mystat where rownum =1);

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

Way3: If DBMS_SUPPORT is installed,select dbms_support.mysid from dual;