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
Enkitec
DBAKevlar.com
________________________________
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.
http://timurakhmadeev.wordpress.com/2012/04/09/method_opt/
--
Regards,
Greg Rahn | blog <http://bit.ly/u9N0i8> | twitter <http://bit.ly/v733dJ> |
linkedin <http://linkd.in/gregrahn>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
