找当前窗口的sid

SQL> select * from v$mystat where rownum=1;


       SID STATISTIC#   VALUE
---------- ---------- ----------
35    0       0


SQL> select sid,SERIAL# from v$session where sid=35;


       SID    SERIAL#
---------- ----------
35  303


SQL> alter system kill session '35,303';
alter system kill session '35,303'
*
ERROR at line 1:
ORA-00027: cannot kill current session




SQL> 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30536096/viewspace-2057109/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30536096/viewspace-2057109/