Re: Queries doing full scan

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Tue, 30 Nov 2004 13:00:36 GMT
Message-ID: <U9_qd.53751$K7.1113@news-server.bigpond.net.au>

"Laura Dorado" <laura.dorado_at_gmail.com> wrote in message news:444e99f5.0411300451.16265a08_at_posting.google.com...
> We need know how to find queries that is doing full scan table.
>
> With the next query we obtein the number of full table scans against
> tables:
>
> select n.name, s.value
> from v$statname n , v$sysstat s
> where n.statistic# = s.statistic#
> order by n.class, n.name
>
>
> but we have not the sql that doing full scan. With the view v$sqlarea
> I obtein the executions, disk_reads, .... of either query but not the
> full scan.
>
> Someone can help me, please?

Hi Laura,

Depending on your version of Oracle, what about v$sql_plan ?

BTW, as the President of the Royal Society For the Prevention of Cruelty To Full Table Scans (RSPCFTS), you do know many of your FTS could be the good guys and that maybe some of your index scans could be the baddies ?

Of course you do.

Cheers

Richard Received on Tue Nov 30 2004 - 07:00:36 CST