Re: AUTO_SAMPLE_SIZE is every row

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 29 Jan 2018 07:26:24 -0800
Message-ID: <CAORjz=P6gN-OTUyBwn20Yjr2zrue_pcEwzqqkd7NsUMKy+Efjw_at_mail.gmail.com>



On Sat, Jan 27, 2018 at 7:34 AM, Mladen Gogala <gogala.mladen_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 29 2018 - 16:26:24 CET

Original text of this message