How to get self SID in Oracle

 

 

SQL> SELECT SYS_CONTEXT ('USERENV', 'CURRENT_SCHEMA') AS username, sys_context('USERENV','SID') "My SID" from dual;

USERNAME       My SID
-------------- --------
SHAAN          138
 

 

SQL> select sys_context('USERENV','SID') "My SID" from dual;

My SID
--------
138