Property to enable: 

customer_overrides.properties changes -
yfs.yfs.app.identifyconnection=Y 

QUERY-1:
=========
       SELECT sysdate,lh.inst_id l_ins, lh.SID lock_sid, lx.client_info||lx.module Locker,
       lx.status Locker_Status, lx.SQL_HASH_VALUE, lx.PREV_HASH_VALUE, ls.client_info||ls.module Waiter,
       ls.status Waiter_Status, ls.last_call_et, do.object_name, lw.inst_id w_ins,
       lw.SID wait_sid,
               DECODE (lh.TYPE,
                       'MR', 'Media_recovery',
                       'RT', 'Redo_thread',
                       'UN', 'User_name',
                       'TX', 'Transaction',
                       'TM', 'Dml',
                       'UL', 'PLSQL User_lock',
                       'DX', 'Distrted_Transaxion',
                       'CF', 'Control_file',
                       'IS', 'Instance_state',
                       'FS', 'File_set',
                       'IR', 'Instance_recovery',
                       'ST', 'Diskspace Transaction',
                       'IV', 'Libcache_invalidation',
                       'LS', 'LogStaartORswitch',
                       'RW', 'Row_wait',
                       'SQ', 'Sequence_no',
                       'TE', 'Extend_table',
                       'TT', 'Temp_table',
                      'Nothing-'
                      ) waiter_lock_type,
               DECODE (lw.request,
                       0, 'None',
                       1, 'NoLock',
                       2, 'Row-Share',
                       3, 'Row-Exclusive',
                       4, 'Share-Table',
                       5, 'Share-Row-Exclusive',
                       6, 'Exclusive',
                       'Nothing-'
                      ) wait_mode_req
          FROM gv$lock lw, gv$lock lh, gv$session ls, gv$session lx, gv$locked_object lo, dba_objects do
          WHERE lh.id1 = lw.id1
          AND lh.id2 = lw.id2
          AND lh.request = 0
          AND lw.lmode = 0
          AND lw.inst_id=ls.inst_id
          AND lx.inst_id=lh.inst_id
          AND lw.sid = ls.sid
          AND lx.sid = lh.sid
          AND lx.inst_id = lo.inst_id
          AND lx.sid = lo.session_id
          AND lo.object_id = do.object_id
          AND (lh.id1, lh.id2) IN (SELECT id1, id2
                                     FROM gv$lock
                                    WHERE request = 0
                                    INTERSECT
                                    SELECT id1, id2
                                      FROM gv$lock
                                     WHERE lmode = 0)
                                    order by lh.inst_id, lh.sid;


QUERY-2:
=========
          select /*+ ordered */ sysdate, s.inst_id, sid, client_info, module, s.status, machine,
                 program, logon_time, last_call_et, lo.object_id, object_name
                 from gv$session s, gv$locked_object lo, dba_objects o
                 where type = 'USER' AND
                 last_call_et > 15 AND
                 s.sid = lo.SESSION_ID AND
                 s.inst_id = lo.INST_ID AND
                 lo.object_id = o.object_id
                 order by s.inst_id, s.sid;