col sql_text format a60 wrap
select disk_reads diskreads, executions, sql_id, sql_text
from(select disk_reads, executions, sql_id, ltrim(sql_text) sql_text, 
      sql_fulltext, operation, options, row_number() over (partition by sql_text order by disk_reads * executions desc) keephighsql
   from(select avg(disk_reads) over (partition by sql_text) disk_reads, 
          max(executions) over (partition by sql_text) executions, 
          t.sql_id, sql_text, sql_fulltext, p.operation,p.options
        from v$sql t, v$sql_plan p
        where t.hash_value=p.hash_value and p.operation='TABLE ACCESS' 
        and p.options='FULL' and p.object_owner not in ('SYS','SYSTEM')
        and t.executions > 1) 
   order by disk_reads * executions desc)
where keephighsql = 1
and rownum <=10;