Question:
How do I easily find sql's that are doing full table scans (FTS)?
Answer 1:
Use the explain plan .........
as described in Tuning Guide.
Its very easy.
Answer 2:
Or you could in Sqlplus, just
set autotrace on
and run the query.
Be sure to have the plan_table installed first though.