caowei3047

原创 ORACLE10G清除死锁进程

select Distinct 'alter system kill session '||chr(39)||b.sid||','||b.serial#||chr(39)||';'As 组装语句在RAC执行时区分节点,b.username,b.logon_time from v$locked_object a,v$session b where a.session_id=b.sid orde...