Oracle forupdate 引起的行锁解决办法

来源：互联网发布：淘宝坏单包赔怎么设置编辑：程序博客网时间：2024/05/21 09:18

select
ls.osuser   os_user_name,
ls.username user_name,

decode(ls.type,
        'RW',
        'Row wait enqueue lock',
        'TM',
        'DML enqueue lock',
        'TX',

        'Transaction enqueue lock',
        'UL',
        'User supplied lock') lock_type,
o.object_name object,
decode(ls.lmode,
        1,
        null,
        2,
        'Row Share',
        3,

        'Row Exclusive',
        4,
        'Share',
        5,
        'Share Row Exclusive',
        6,
        'Exclusive',
        null)

lock_mode,
o.owner,
ls.sid,
ls.serial# serial_num,
ls.id1,
ls.id2

from sys.dba_objects o,
       (select s.osuser,
               s.username,
               l.type,

               l.lmode,
               s.sid,
               s.serial#,
               l.id1,
               l.id2
          from v$session s,

               v$lock l
         where s.sid = l.sid) ls
where o.object_id = ls.id1
   and o.owner

       <> 'SYS'
order by o.owner, o.object_name;