Hi guys,

I have a reasonably big application. It is very difficult to find and
analyze each and every
SQL statement to see all the full table scans (FTS) happening in the system.
If I would like to find what all
Tables are getting FTS during normal operations then how should I do that ?

Is there any event or trace option available ?

Pls. advise
Thanx and regards

Oracle LazyDBA home page