RE: Information about User-defined Locks

Listers: Solved my own problem and thought I would share the solution with you all. To find the name of a user-defined lock: SELECT s.sid , s.serial# , DECODE( s.process , NULL, DECODE(SUBSTR(p.username, 1, 1), '?', UPPER(s.osuser), p.username)

Re: Information about User-defined Locks

Jon, Try doing the following, it should give you the information, you need :- SELECT o.object_id, s.username, l.sid, object_name, DECODE( l.type, 'MR', 'Media Recovery',