join v$sql_plan
571266Jun 19 2007 — edited Jun 20 2007Hi,
I have this query and I want to join v$sql_plan. How can I do it
select sq.* from
(select sql_text,disk_reads, rank() over (order by disk_reads desc) as ranking from v$sqlarea) sq
where ranking <5
this query is not exactly what I want . I want distinct rows
select * from
(select t.sql_text,t.disk_reads,p.* from v$sqlarea t, v$sql_plan p
where t.hash_value=p.hash_value
order by DISK_READS DESC)
where rownum<6