1 . 使用sys_context()
SYS@CH> select sys_context('userenv', 'sid') from dual;
SYS_CONTEXT('USERENV','SID')
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
159
2. 使用视图v$mystat
SYS@CH> select distinct sid from v$mystat;
SID
----------
159

