Re: AUTO_SAMPLE_SIZE is every row

I recall some of them being published here:

Things to Consider to Avoid Poor Performance or Wrong Results on 12.1.0.2 (Doc ID 2034610.1)

Particularly this one crippled data warehouses:

Document 20636003.8
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2034610.1&id=20636003.8>  Slow Parsing caused by Dynamic Sampling (DS_SVC) queries (side effects possible ORA-12751/ ORA-29771)

Stefan

On Mon, Jan 29, 2018 at 10:26 PM, Jared Still <jkstill_at_gmail.com> wrote:

>
> 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
>
>

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat |
_at_zztat_oracle

--
http://www.freelists.org/webpage/oracle-l