Tracing sql statements using v$sqlarea

[sonaliak]

Try this one:
this
/*will break the query into segments of 64 bytes and there will be multiple rows
/*per statement, depending on length of query*/
select disk_reads, executions, disk_reads/executions, b.sql_text, first_load_time
from v$sqlarea a, v$sqltext b
where a.address=b.address and disk_reads/decode(executions,0,1,executions) > 100
and executions > 0
order by disk_reads/decode(executions,0,1,executions) desc,b.address, b.piece;