Subject: Re: Varying plans on different nodes

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 <fairlie_r_at_yahoo.com>
> 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