857: SH.TERMINAL,
858: SH.PROGRAM
859: into UName, UProcess_ID, UNode, UTerminal, UProgram
860: from V$SESSION SH,
861: V$LOCK LW,
862: V$LOCK LH,
863: V$SESSION SW
864: where LH.SID = SH.SID
865: and LH.SID <> SW.SID
858: SH.PROGRAM
859: into UName, UProcess_ID, UNode, UTerminal, UProgram
860: from V$SESSION SH,
861: V$LOCK LW,
862: V$LOCK LH,
863: V$SESSION SW
864: where LH.SID = SH.SID
865: and LH.SID <> SW.SID
866: and LH.ID1 = LW.ID1