-- 查看被锁的表
select sess.SID,sess.SERIAL#,lo.ORACLE_USERNAME,
lo.OS_USER_NAME,ao.OBJECT_NAME,lo.LOCKED_MODE
from v$locked_object lo, dha_obiects ao ,v$session sess
where ao.OBJECT_ID=lo.OBJECT_ID and lo.SESSION_ID=sess.SID;
-- 正在执行的sql
select b.SID oracleId,
b.USERNAME,
b.SERIAL#,
spid,
paddr,
b.machine
from v$session b
left join v$process a on a.addr=b.paddr
left join v$sqlarea c on b.sql_hash_value=c.hash_value
where sql_text is not null;
-- 杀掉进程 sid,serial#
ALTER SYSTEM KILL SESSION '666,9527';
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交