Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

join v$sql_plan

571266Jun 19 2007 — edited Jun 20 2007
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2007
Added on Jun 19 2007
3 comments
342 views