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;输入表的名字即可,kill掉锁这个表的session即可
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;输入表的名字即可,kill掉锁这个表的session即可
SQL> kill -9 14807;
未知命令开始"kill -9 14..." -- 其余行忽略。