Re: Full Table Scans

From: Oradba Linux <techiey2k3_at_comcast.net>
Date: Tue, 8 Feb 2005 14:29:04 -0500
Message-ID: <W4-dnTOMNLVVj5TfRVn-jw@comcast.com>

"Thiko!" <biwombi_at_hotmail.com> wrote in message news:1107862438.607672.325800_at_f14g2000cwb.googlegroups.com...
> Hi
>
> We have monitoring software which is telling us that many full table
> scans are happening in the database.
>
> We want to reduce this if possible.
>
> Is there any SQL to use to tell what is doing the full tablescans?
> e.g. the database user and the select statement? It is becoming
> tedious checking the top sql and seeing if it doing full table scans.
>
> Many thanks.
>
> Thiko!
>

If you are oracle 9i then use v$sql_plan to find out which tables are being full scanned.
But as others answered it might help to find the offending SQL and go from there. Received on Tue Feb 08 2005 - 13:29:04 CST