Re: SQL execution time

This report Resource Intensive Queries

select disk_reads phy_reads, sql_text
from v$sqlarea
where disk_reads > 20000;  

select buffer_gets log_reads, sql_text from v$sqlarea
where buffer_gets > 100000;

Hope this help
FreD

Boon Tan <btan10_at_visto.com> wrote in article <3830af64$0$221_at_nntp1.ba.best.com>...
> Anyone knows how to extract the the most expesnive queries with the
> execution time (or elapse time) of each of the query?
> Thanks...
>
> btan_at_corp.visto.com
>
> -Boon
>
>
>
Received on Tue Nov 16 1999 - 03:33:44 CST