RE: URGENT - LOCK

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Fri, 27 Oct 2000 15:15:12 +0100
Message-Id: <10662.120447@fatcity.com>

select l.kaddr kaddr,
       u.name owner,
       o.name object,
       l.sid sid,
       s.username username,
       l.type type,
       id1,
       id2,
       lmode,
       decode(lmode, 1, 'NULL', 2, 'Row Share', 3, 'Row Exclusive', 4,


'Share', 5, 'Share Row', 6, 'Exclusive') mode_desc,

       request,
       decode(request, 1, 'NULL', 2, 'Row Share', 3, 'Row Exclusive', 4,

'Share', 5, 'Share Row', 6, 'Exclusive') request_desc
  from v$lock l,

       v$session s,
       sys.obj$ o,
       sys.user$ u
 where l.type in ('RW', 'TM', 'TX', 'UL')
   and l.sid = s.sid (+)

   and l.id1 = o.obj# (+)
   and o.owner# = u.user# (+)
 order by id1,

          id2,
          lmode
---------------------------------

Received on Fri Oct 27 2000 - 09:15:12 CDT