Re: Full tablescans on long tables

Have you used query plan to look at the queries that you think are causing the problem.

The query plan will tell you which tables are being scanned and allow you to tune your queries/database.

"Keith Jamieson" <Keith.Jamieson_at_phoenix.ie> wrote in message news:99vl2d$a23$1_at_kermit.esat.net...
> After running utlbstat.sql and utlestat.sql, I get a lot of full table
 scans
> on long tables(ie more than 5 data blocks).
>
> Is there any utility, view etc which will let me see what the names of
 these
> long tables being accessed are.
>
> Essentially, I want to see if its one or two particular tables which are
> being hit frequently, or whether I have a problem in General.
>
> TIA.
>
> Keith Jamieson
>
>
>
>
Received on Sat Apr 07 2001 - 08:53:27 CDT