Useful Views
-
编辑 删除
V$LOCK vs DBA_DML_LOCK
Get current locks:SQL> select s.username "Session User",l.sid "Lock Session",l.type "Lock Type",DECODE(l.lmode, 0, 'None', 1, 'Null', 2, 'Row Share', 3, 'Row Excl.', 4,'Share', 5, 'S/Row Excl.', 6, 'Exclusive', LTRIM(TO_CHAR(Lmode,'990')))"Lock Mode",DECODE(l.Request, 0, 'None', 1, 'Null', 2, 'Row Share', 3, 'Row Excl.', 4,'Share', 5, 'S/Row Excl.', 6, 'Exclusive', LTRIM(TO_CHAR(l.Request, '990')))"Request",l.Id1, l.Id2,d.owner||'.'||d.object_
