oracle删除链接

1、查询锁定的进程
select Distinct 'alter system kill session '||chr(39)||b.sid||','||b.serial#||chr(39)||';'As sql,b.username,b.logon_time
from v$locked_object a,v$session b where a.session_id=b.sid order by b.logon_time;

select * from v$locked_object;

2、查询链接的进程

select 'alter system kill session '''||sid||','||serial#||''';' from v$session where username='KLINIT';

select * from v$session;