Re: Full table scans

From: Antoine BRUNEL <antoinebrunel_at_yahoo.fr>
Date: Tue, 6 May 2003 19:36:34 +0200
Message-ID: <3eb7f2a4$0$7597$79c14f64@nan-newsreader-02.noos.net>

Hi from Paris

big question....

One efficient way, is to use Perfstat, a tool supplied since version 8i (but exists for 8.0).

Taking snapshots with level > 5 will track some good candidates for SQL optimisation.

A smarter way is to dynamically check V$SQLAREA view, ordering by executions, buffer_gets / executions and buffer_gets.

Cdlt
"Kalle" <kminerva_at_jippii.fi> a écrit dans le message de news:3EB79950.8CA5BA2F_at_jippii.fi...
> Hi all,
>
> how I am able to locate the worst possible sql-statements from sga..
>
> Merci Beaucoup...
>
> Kalle
>
Received on Tue May 06 2003 - 12:36:34 CDT