select s.sid , s.serial#, p.spid ospid, q.sql_text , s.sql_child_number
from v$process p, v$session s, v$sqlarea q
where p.addr = s.paddr
and s.sql_id=q.sql_id(+) ;
select s.sid , s.serial#, p.spid ospid, q.sql_text , s.sql_child_number
from v$process p, v$session s, v$sqlarea q
where p.addr = s.paddr
and s.sql_id=q.sql_id(+) ;