View SID for your session

select distinct sid from v$mystat;

or

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

or


select to_number(substr(dbms_session.unique_session_id,1,4),'XXXX') mysid from dual;