【原创精华】Oracle表死锁操作

死锁查询

[code]select object_name, machine, s.sid, s.serial#from gv$locked_object l, dba_objects o, gv$session swhere l.object_id　 = o.object_idand l.session_id = s.sid;

解锁

[code]--语法alter system kill session \'sid, serial#\';--解锁alter system kill session \'11, 2222\';