Finding the current session's ID

select sid, serial# from v$session where audsid = sys_context('userenv','sessionid');

Or, if you're only interested in the sid, not in serial#:
select distinct sid from v$mystat;

Note, the selected sid has nothing to do with the System Identifier. If dbms_support is installed, the current sid can also be found with its mysid function:

select dbms_support.mysid from dual;

Thanks to Jan Arnoldus who pointed out an error on this page!

dbms_support的包位于 ?/rdbms/admin/dbmssupp.sql 文件中

引自 http://www.adp-gmbh.ch/ora/misc/find_my_sid.html

[@more@]完

ITPub博客

茴字的三种写法-找出当前会话ID

最新文章