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就好
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就好