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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27042095/viewspace-738084/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27042095/viewspace-738084/