oracle中,如何解除表的锁

ayyaayy

oracle中,如何解除表的锁

whbilly

select b.sql_text text,a.sid sid ,a.serial# sria#,a.username username, c.type type,a.machine machine
from v$session a ,v$sqltext b ,v$access c
where c.object=upper('&1')
and c.type in ('TABLE','PACKAGE','PROCEDURE','FUNCTION','PACKAGE BODY')
and a.sid=c.sid
and b.address = a.sql_address
and b.hash_value = a.sql_hash_value
order by a.sid,a.serial#,b.piece;

输入表名字，看看什么session在锁表，kill就好

ayyaayy

谢谢 我去看下

wait7788

同意一楼的。