Re: Optimizer statistics poll

  • From: David Fitzjarrell <oratune@xxxxxxxxx>
  • To: "mark.powell2@xxxxxx" <mark.powell2@xxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 10 Apr 2012 09:35:21 -0700 (PDT)

Agreed; I responded based upon our use of 10.2.0.x for some clients where using 
the default values for statistics gathering can throw a 'spanner into the 
works' (so to speak).  Partitioned tables are especially prone to basically 
useless statistics -- frequency histograms on single-valued non-null columns 
and histogram counts based on the sample size rather than extrapolatng the 
results to reflect the entire table come to mind.
It would be a nice to have these results broken down by version.
David Fitzjarrell

From: "Powell, Mark" <mark.powell2@xxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> 
Sent: Tuesday, April 10, 2012 10:18 AM
Subject: RE: Optimizer statistics poll

I think the poll is valid providing you understand the limitation of the result 
due to the lack of version specificity.  The results would be much more useful 
if broken down by version.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Kellyn Pot'vin
Sent: Monday, April 09, 2012 7:25 PM
To: greg@xxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Optimizer statistics poll

Hey Greg,
As was *whined* about earlier...:)  -Aren't the results biased and considerably 
incorrect due to the lack of Oracle version referenced in the poll?
Kellyn Pot'Vin
Senior Technical Consultant

From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, April 9, 2012 4:58 PM
Subject: Optimizer statistics poll

Please consider participating in this poll.

Greg Rahn  |  blog <>  |  twitter <>  | 
linkedin <>



Other related posts: