Oracle锁表解决方案

一：查看完成等待事件的SQL

select distinct a.sid,
a.event,
a.seconds_in_wait,
a.wait_class,
c.sql_text,
c.SQL_ID,
d.spid,
b.OSUSER,
b.USERNAME,
d.program
from gv$session_wait a, gv$session b, gv$sqlarea c, gv$process d
where a.sid = b.sid
and a.state = 'WAITING'
and b.sql_hash_value = c.hash_value(+)
and b.paddr = d.addr
and a.wait_class <> 'Idle';

二：查询锁表

select sess.sid,
sess.serial#,
lo.oracle_username,
lo.os_user_name,
ao.object_name,
lo.locked_mode
from GV$locked_object lo, dba_objects ao, Gv$session sess
where ao.object_id = lo.object_id
and lo.session_id = sess.sid;

三：删除锁表语句

alter system kill session '4898,49875' immediate;--分别为SID和SERIAL#号