Get the current Session ID

SELECT TO_NUMBER(SUBSTR(dbms_session.unique_session_id,1,4),'XXXX') SID#
from dual;