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’;
Recent Posts