926: SH.TERMINAL,
927: SH.PROGRAM
928: into UName, UProcess_ID, UNode, UTerminal, UProgram
929: from V$SESSION SH,
930: V$LOCK LW,
931: V$LOCK LH,
932: V$SESSION SW
933: where LH.SID = SH.SID
934: and LH.SID <> SW.SID
927: SH.PROGRAM
928: into UName, UProcess_ID, UNode, UTerminal, UProgram
929: from V$SESSION SH,
930: V$LOCK LW,
931: V$LOCK LH,
932: V$SESSION SW
933: where LH.SID = SH.SID
934: and LH.SID <> SW.SID
935: and LH.ID1 = LW.ID1