Re: db file scattered read

On 08/07/2004 02:49:04 AM, Wolfgang Breitling wrote:
> In my earlier note I reported that a test confirmed my suspicion that the
> CBO in many cases does either not invoke dynamic sampling, or disregards
> the results even when it does.

I was judging based on the plan, I didn't do 10053. Now you got me really interested. I'll drop statistics on the user scott, and perform 10053 trace.

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