大家好，又见面了，我是你们的朋友全栈君
一.查询锁定的表
如下语句，都可以查询锁定的表
语句一：
select a.sid,
a.serial#,
p.spid,
c.object_name,
b.session_id,
b.oracle_username,
b.os_user_name
from vprocess p, vsession a, v
where p.addr = a.paddr
and a.process = b.process
and c.object_id = b.object_id
and c.OBJECT_name = ‘TABLE_NAME’;
语句二：
SELECT s.sid, s.serial#, o.object_name, s.machine
FROM gvlocked_object l, dba_objects o, gvsession s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid
AND o.object_name = ‘TABLE_NAME’;
语句三：
SELECT l.session_id sid,
s.serial#,
l.locked_mode,
l.oracle_username,
l.os_user_name,
s.machine,
s.terminal,
o.object_name,
s.logon_time
FROM vlocked_object l, all_objects o, vsession s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid
AND o.object_name = ‘TABLE_NAME’
ORDER BY sid, s.serial#;
语句四：
select a.sid,
b.serial#,
c.object_name,
decode(a.lmode,
0,
‘None’,
1,
‘Null’,
2,
‘Row-S’,
3,
‘Row-X’,
4,
‘Share’,
5,
‘S/Row-X’,
6,
‘Exclusive’,
‘Unknown’) LockMode,
B.MACHINE,
D.SPID,
b.PROGRAM
from vlock a, vsession b, all_objects c, V
where a.sid = b.sid
and a.type in (‘TM’, ‘TX’)
and c.object_id = a.id1
and B.PADDR = D.ADDR
and c.object_name = ‘TABLE_NAME’;
二.kill掉锁住的进程，解锁
–释放SESSION SQL
alter system kill session ‘SID,serial#’;
发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/172325.html原文链接：https://javaforall.cn
到此这篇oracle查看锁表杀死锁（查看oracle锁表语句）的文章就 介绍到这了,更多相关内容请继续浏览下面的相关 推荐文章，希望大家都能在编程的领域有一番成就！版权声明：
本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如若内容造成侵权、违法违规、事实不符，请将相关资料发送至xkadmin@xkablog.com进行投诉反馈，一经查实，立即处理！
转载请注明出处，原文链接：https://www.xkablog.com/rfx/31793.html