Re: How to identify SQLText of a Process/Session?
From: Bryon Cho <bryon.cho_at_intelsat.int>
Date: 1996/04/05
Message-ID: <4k48u9$jg5_at_intelsat2.intelsat.int>#1/1
Date: 1996/04/05
Message-ID: <4k48u9$jg5_at_intelsat2.intelsat.int>#1/1
we have had success with this sql.
select *
from v$session a, v$process b, v$sqlarea c
where a.paddr = b.addr
and a.sql_hash_value=c.hash_value
and spid = <unix process id>
good luck. Bryon Cho. Received on Fri Apr 05 1996 - 00:00:00 CEST