execute this sql, IN spid give your OS pid number
select a.serial#,a.osuser,a.program,a.machine,c.sql_text from v$session a, v$process b,v$sqlarea c
where a.paddr=b.addr
and b.spid=&spid
and a.sql_hash_value=c.hash_value
/
|
Results 1 to 3 of 3
Threaded View
|
Click Here to Expand Forum to Full Width |