1.查看自己需要的SID
select sid ,serial#,username from v$session;
SID SERIAL# USERNAME
---------- ---------- ------------------------------
243 17 SYS
252 3
254 5 MANAGER
255 3 MANAGER
删除
2. alter system kill session '254,5';
select sid ,serial#,username from v$session;
SID SERIAL# USERNAME
---------- ---------- ------------------------------
243 17 SYS
252 3
254 5 MANAGER
255 3 MANAGER
删除
2. alter system kill session '254,5';