先查出会话ID select sid,serial#,username,status
from v$session
where username is not null;然后:
alter system kill session 'sid,serial#' ;
例如:
SQL> select sid,serial#,username,status from v$session
where username = 'TEST'; SID SERIAL# PADDR USERNAME STATUS
---------- ---------- -------- ------------------------------ --------
11 314 542B70E8 TEST INACTIVESQL> alter system kill session '11,314';System altered.
from v$session
where username is not null;然后:
alter system kill session 'sid,serial#' ;
例如:
SQL> select sid,serial#,username,status from v$session
where username = 'TEST'; SID SERIAL# PADDR USERNAME STATUS
---------- ---------- -------- ------------------------------ --------
11 314 542B70E8 TEST INACTIVESQL> alter system kill session '11,314';System altered.
!