select a.*,c.sql_text
from
(
select s.*, p.spid as pid
from
(
select a.*,b.username,b.sid,b.serial#,b.logon_time,b.paddr,b.sql_hash_value
from
(
select b.owner,b.object_name,a.session_id,a.locked_mode
from v$locked_object a,dba_objects b
where b.object_id = a.object_id
--and object_name like 'REPORT_%'
) a ,v$session b
where a.session_id = b.sid order by a.object_name
-- sqlplus里:alter system kill session 'sid,serial#';
) s, v$process p
where s.paddr = p.addr
-- 服务器shell里:kill -9 pid
) a, v$sqlarea c
where a.sql_hash_value = c.hash_value
oracle 查看锁表
最新推荐文章于 2023-04-21 16:38:50 发布