当前位置 博文首页 > weixin_30892889的博客:ORACLE锁表原因查询和解决办法

    weixin_30892889的博客:ORACLE锁表原因查询和解决办法

    作者:[db:作者] 时间:2021-09-07 10:14

    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