Re: How to Monitor if "table scans" occur

mikea730_at_my-deja.com wrote:

> Is there any kind of performance view that collects statistics
> on table
> scans. I'm familiar with using "EXPLAIN PLAN" when the SQL
> statement
> is known. I need to monitor from the server side to determine
> if an
> excessive number of table scans are occuring. I need to then
> be able to isolate the SQL statement.
>
> Thanks in advance for any help!!
>
> Mike
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

        Download OraSnap (www.stewartmc.com/oracle/orasnap/). Among it's 100 or so queries are two that report on full table scans.

-- 
Jerry Gitomer
Once I learned how to spell DBA, I became one