Re: Full Table Scans

"Thiko!" <biwombi_at_hotmail.com> wrote:
> Hi
>
> We have monitoring software which is telling us that many full table
> scans are happening in the database.

Throw away the software.

>
> We want to reduce this if possible.
>
> Is there any SQL to use to tell what is doing the full tablescans?

Isn't that what you buy monitoring software for? Throw away the software.

> 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.

If the full table scans aren't showing up among the top sql the first couple times you check them, then it is very likely that they aren't actually a problem, no matter what some monitoring software says.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB