Re: Query for Top 10 Most "Expensive" Queries

alvathinstruct_at_hotmail.com (Allan Vath) 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

Something like:

select disk_reads, sql_text

        from    v$sqlarea
        where disk_reads > 10000
        order by disk_reads desc

But listen to Tanel.

jg

--
@home.com is bogus.
I am Sir Oracle, and when I ope my lips, let no dog bark! -
Shakespeare, Merchant of Venice