Subject: Re: Varying plans on different nodes
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Jun 2007 21:06:44 +0100
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@xxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
