select snap_id,instance_number,sql_id,sql_text,hash_value,sum(disk_reads) Total_Disk_Reads,sum(buffer_gets) Total_Buffer_gets 
from 
stats$sql_summary where snap_id between &Begin_Snap and &End_Snap 
group by snap_id,instance_number,sql_id,sql_text,hash_value having sum(disk_reads)>100000 order by Total_disk_reads desc;