To find Sqltext based on the SID

select sql_text from v$sqltext a,v$session b where a.address=b.sql_address and b.sid=&sidnumber order by piece;

select b.sid, b.serial#,b.username,a.sql_text, a.address, a.hash_value from v$sqltext a,v$session b where a.address=b.sql_address and b.sid=’&SID’;

Doyensys

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.