Re: Subject: Re: Varying plans on different nodes

I don't have 10.1.0.5 available, but my 10.2 instances don't gather system stats in the gather_stats_job.

What do the contents of sys.aux_stats$ look like, and what are the instance values for the three parameters I listed.

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- From: "fairlie rego" <fairlie_r_at_yahoo.com> To: <jonathan_at_jlcomp.demon.co.uk> Cc: <oracle-l_at_freelists.org> Sent: Friday, June 08, 2007 10:24 PM Subject: Re: Subject: Re: Varying plans on different nodes

> Jonathan
>
> DB version : 10.1.0.5
>
> System stats are gathered by Oracle's default job which runs in the default
> window.
>
> Thanks
> Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> Are you running 10.1 or 10.2
> Have you gathered system stats, or do you let
> Oracle set the noworkload values on startup.
>
> If the latter,
> Have you set the db_file_mulitblock_read_count
> If not,
> What is the value of "processes"
> What was the size of the db_cache at the time the
> queries were optimised
>
> Regards
>
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentals
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>>
>> ------------------------------
>>
>> Date: Thu, 7 Jun 2007 10:22:41 -0700 (PDT)
>> From: fairlie rego
>> Subject: Re: Varying plans on different nodes
>>
>> Thanks for your emails
>>
>> Its 3:00 am in windy and rainy Sydney and not sure why Fairlie is actually
>> awake.
>>
>> The plans are indeed same with workarea_size_policy MANUAL (i.e no MJC)
>>
>> Thanks
>> Fairlie
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
> Fairlie Rego
> Senior Oracle Consultant
> http://el-caro.blogspot.com/
> M: +61 402 792 405
>

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