Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Finding sql's that are doing FTS.
Use the explain plan .........
as described in Tuning Guide.
Its very easy.
screwbai_at_my-deja.com wrote:
> How do I easily find sql's that are doing full table scans (FTS).
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
--