Re: AUTO_SAMPLE_SIZE is every row

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • Date: Mon, 29 Jan 2018 07:26:24 -0800

On Sat, Jan 27, 2018 at 7:34 AM, Mladen Gogala <gogala.mladen@xxxxxxxxx>
wrote:


I couldn't agree more. I'm testing a setup with one of my clients, with
OPTIMIZER_DYNAMIC_SAMPLING=11. So far, everything looks right. There were
crippling bugs with that setting but after a few proactive bundles, things
look stable.


Mladen,

Which version of Oracle was this?

Also, what were some of the crippling bugs?

I am familiar with some of these bugs in 11g, but not so much if this is in
12c.



Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/
Github: https://github.com/jkstill

Other related posts: