Go for statspack report

-----Original Message-----
From: Puneyani, Rajesh [mailto:[Email Address Removed] Thursday, November 27, 2003 1:34 PM
To: LazyDBA.com Discussion
Subject: Finding all the FULL TABLE SCANS in the system


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


--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page