Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 --------------------------------- Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 08 2007 - 16:24:28 CDT
![]() |
![]() |