DB Lock 조회

SELECT b.object_name     , a.oracle_username ,
             a.session_id      , a.os_user_name    ,
             a.process                             ,
             decode(a.locked_mode, 0,      'None', 1,         'Null',
                                   2, 'Row-s(ss)', 3,    'Row-x(sx)',
                                   4,     'Share', 5, 'S/Row-x(ssx)',
                                   6, 'Exclusive', to_char(a.locked_mode))
        FROM v$locked_object a, dba_objects b
       WHERE a.object_id = b.object_id ;