set lines 120 col sess format a15 SELECT DECODE(request,0,’Holder: ‘,’ Waiter: ‘)||sid sess,id1,id2, lmode,inst_id, request, type FROM GV$LOCK WHERE (id1, …