Re: db file scattered read

On 08/15/2004 01:11:21 PM, Wolfgang Breitling wrote:
> Mladen,
>
> Read my original statement. Nowhere did I say that dynamic sampling does
> not work. I only stated that only non-analyzed tables are guaranteed to be
> sampled - and if none of the tables are analyzed you have to first force
> the use of the CBO - and that in the case of dynamic sampling of analyzed
> tables, the CBO may discard the sampling results and stay with the
> dictionary statistics.
>

Oh, I see. Then, it was a misunderstanding for which I'm grateful, because it motivated me to do some testing, after upgrading to 10.1.0.3. Quite unrelated to that, I haven't had any problems with upgrading to 10.1.0.3 on Linux, if anybody is curious. Everything gets linked flawlessly and catpatch runs without any problems. After a lenthy upgrade that took me a better part of the morning, and some testing to see how it behaves, I'm off for a well deserved lunch.

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------