数据库资讯

oracle 锁问题的解决

作者: 来源:未知 文章标签:
',
                
5, 'S/Row Excl.',
                
6, 'Exclusive',
                 lmode,
LTRIM (TO_CHAR (lmode, '990'))
                ) lmode,
         DECODE (m.request,
                
0, 'None',
                
1, 'Null',
                
2, 'Row Share',
                
3, 'Row Excl.',
                
4, 'Share',
                
5, 'S/Row Excl.',
                
6, 'Exclusive',
                 request,
LTRIM (TO_CHAR (m.request, '990'))
                ) request,
         m.id1, m.id2
   
FROM v$session sn, v$lock m
  
WHERE (sn.SID =

评论交流