当前位置 博文首页 > weixin_30892889的博客:ORACLE锁表原因查询和解决办法
1. ORACLE中查看当前系统中锁表情况?
查询SQL如下:?
select sess.sid,
sess.serial#,
lo.oracle_username,
lo.os_user_name,
ao.object_name,
lo.locked_mode
from v$locked_object lo, dba_objects ao, v$session sess, v$process p
where ao.object_id = lo.object_id
and lo.session_id = sess.sid
and object_name = 'MOV_MSTR'
cs