Re: Query for Top 10 Most "Expensive" Queries

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Tue, 26 Aug 2003 01:41:34 +0300
Message-ID: <3f4a909f$1_1@news.estpak.ee>

Hi!

select * from (
select rownum r, sql_text from v$sql where buffer_gets > 100000 order by buffer_gets desc
)
where rownum <= 10;

This shows you logical IO and logical IO is on what you should focus first. (the 100000 is there because otherwise there is too many rows to sort in inner query)

Tanel.

"Allan Vath" <alvathinstruct_at_hotmail.com> wrote in message news:7eeea21b.0308251049.5dd27b54_at_posting.google.com...
> I once had the sql which read a sys view which listed the top 10 worst
> queries (as judged by high I/O). Can someone save me the time in
> searching the sys views for this query.
>
> Thanks,
>
> Allan Vath
Received on Mon Aug 25 2003 - 17:41:34 CDT