RE: sequential read on full-table scan?

Hi Zoran

>The main question is how good is that prediction based
>on the global system statistics only.
>Not sure how these statistics if collected per file or
>object level will be more useful???

If you want to have really good statistics you should add either a time = dimension and some kind of forecasting (regression?) or real-time = statistics.

Of course both have major problems... e.g.: What about segments that = span more files? What about partitioned objects? When are the cached = execution plans invalidated?=20

IMHO it's better to KISS.

Just my 2 cents!
Chris

--
http://www.freelists.org/webpage/oracle-l