Oracle Locks

From: Paul Walker <walkerp1_at_yahoo.com>
Date: 27 Jun 2001 15:27:56 -0700
Message-ID: <9cef9a4a.0106271427.5900471e@posting.google.com>

The following was posted by Tracie Thomas, but wasn't quite complete (the from clause got skipped). The following query includes the missing information:

select vs.sid,

    vs.serial#,
    vs.username,
    u.name owner,
    o.name object_name,
    vs.username,
    u.name owner,
    o.name object_name,
    id1 object_id,

    decode(o.type, 0, 'NEXT OBJECT',   1, 'INDEX',         2, 'TABLE',
                   3, 'CLUSTER',       4, 'VIEW',          5,


'SYNONYM',

                   6, 'SEQUENCE',      7, 'PROCEDURE',     8,


'FUNCTION',

                   9, 'PACKAGE',      11, 'PACKAGE BODY', 12,


'TRIGGER',

                      'UNDEFINED') object_type,
    decode( vl.lmode,
        1,null,
        2,'Row Share',
        3,'Row Exclusive',
        4,'Share',
        5,'Share Row Exclusive',
        6,'Exclusive')
from v$session vs,
     v$lock vl,
     sys.user$ u,
     sys.obj$ o

where o.owner# = u.user#
and o.obj# = vl.id1
and vs.sid = vl.sid
and vl.type IN ('TM')
/

Paul K.E. Walker Received on Wed Jun 27 2001 - 17:27:56 CDT