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@xxxxxxxxx>
To: <jonathan@xxxxxxxxxxxxxxxxxx> Cc: <oracle-l@xxxxxxxxxxxxx> Sent: Friday, June 08, 2007 10:24 PM Subject: Re: Subject: Re: Varying plans on different nodes
Jonathan DB version : 10.1.0.5System stats are gathered by Oracle's default job which runs in the default window.Thanks Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx> 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-- //www.freelists.org/webpage/oracle-l Fairlie Rego Senior Oracle Consultant http://el-caro.blogspot.com/ M: +61 402 792 405
-- //www.freelists.org/webpage/oracle-l