Re: Subject: Re: Varying plans on different nodes
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "fairlie rego" <fairlie_r@xxxxxxxxx>
- Date: Fri, 8 Jun 2007 22:55:26 +0100
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.5
System 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
Other related posts:
