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

Hi Mike,

you didn't mention you oracle version.
With 9i the view v$sql_plan shows all the cached execution plan.

Hope this helps
Stefan

Mike F wrote:

> 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 Sat Mar 02 2002 - 22:38:35 CST