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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: