'null', 2, 'row-s (ss)', 3, 'row-x (sx)', 4, 'share', 5, 's/row-x
(ssx)', 6, 'exclusive', to_char(lmode)) mode_held, decode(request,
0, 'none', 1, 'null', 2, 'row-s (ss)', 3, 'row-x (sx)', 4,
'share', 5, 's/row-x (ssx)', 6, 'exclusive', to_char(request))
mode_requested, o.owner||'.'||o.object_name||'
('||o.object_type||')', s.type lock_type, l.id1 lock_id1, l.id2
lock_id2 from v$lock l, sys.dba_objects o, v$session s where l.sid
= s.sid and l.id1 = o.object_id ;
30. 如何解鎖