oracle查锁及解锁命令
查询行锁语句
select sql_text from v$sql a,v$session b
where a.sql_id=b.sql_id and b.event='enq: TX - row lock contention';
找到被锁定的表
SELECT object_name, machine, s.sid, s.serial#
FROM gv$locked_object l, db...
原创
2020-04-04 13:41:56 ·
310 阅读 ·
0 评论