Re: query tuning

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Fri, 07 Nov 2003 04:58:02 GMT
Message-ID: <sDFqb.7971$5r5.5541@news02.roc.ny>

"rpr" <renu_p_r_at_yahoo.com> wrote in message news:71802af1.0311061555.634549fd_at_posting.google.com...
> Hello,
> Is there init param setting that will help me identify queries doing
> full table scans. Is there a way to filter these. say by tables. For
> example full table scan on small tables is fine. Thanks
Nope .. there isn't.

Do a describe of v$sqlarea view.

Unless you can't figure how to use this view, you are not that qualified to tune the queries either.

Anurag Received on Thu Nov 06 2003 - 22:58:02 CST