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>
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:
>
Which version of Oracle was this?
Also, what were some of the crippling bugs?
> 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,
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-lReceived on Mon Jan 29 2018 - 16:26:24 CET