Estrazione di un sql statement

v$sqlarea

v$sqltetx

v$sql_monitor

select SQL_TEXT 

from v$sqlarea 

where address in (select sql_address from v$session where sid=&sid);

select SQL_TEXT 

from v$sqlarea 

where address in

 (select sql_address 

from v$session where sid in

(select s.sid from v$process p, v$session s where s.paddr=p.addr and p.spid =&spid));