Re: Is there any way we can find full table scan?

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Sun, 24 Feb 2002 16:43:50 GMT
Message-ID: <aL8e8.4502$FE4.283711@bgtnsc04-news.ops.worldnet.att.net>

Or, you can use Oracle Enterprise Manager with all the optional packs, and use the Tune / Analyze / Recommend facility, gather data for about 12 hours and run the analysis. It'll even write SQL for you to correct certain problems, like indexes you ought to have, but don't. Or indices you do have, but aren't using. Or tuning you can do in your init.ora .

(Oh, but do be careful, don't just run the generated SQL without editing it.)

RSH. "Mike F" <dbadba62_at_hotmail.com> wrote in message news:u1Dd8.2744$Hg1.619_at_nwrddc02.gnilink.net...
> Is there any way we can tell whether there is a full table scan in our
> database and which table it is?
>
> Thanks
>
>
Received on Sun Feb 24 2002 - 10:43:50 CST