Re: Finding slow executing statements

Hi

I would use TKPROF to trace the slow statements but you might also be able to use v$sqlarea to identify sql that has a lot of disk hits - that would be slow...

select sql_text, executions, disk_reads from v$sqlarea where disk_reads =(select max(disk_reads) from v$sqlarea);

In 9i there are additional columns for cpu_time and elapsed_time.

Alistair

"Steven Pannell" <steven.pannell_at_gmx.net> wrote in message news:a3ecne$17otsn$1_at_ID-82797.news.dfncis.de...
> Hi,
>
> I am wondering if there anyway that I can retrieve slow executing
statements
> from the oracle database without switching on the trace files. Or is the
> only way to find out how long SQL statements take is with tkprof.
Basically
> I just want to find out which statements are taking a long time to execute
> on the database. is there a v$ table I can get this information??
>
> Thanks for any help,
> Steve,
>
>
>
Received on Fri Feb 01 2002 - 11:10:21 CST