SELECT a.sid, b.owner, b.object_name, b.object_type FROM v$lock a, all_objects b WHERE TYPE = 'TM' and a.id1 = b.object_id