Re: AUTO_SAMPLE_SIZE is every row
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 29 Jan 2018 19:47:15 -0500
Message-ID: <ff3b9651-524f-7940-282c-2006857be93b_at_gmail.com>
Date: Mon, 29 Jan 2018 19:47:15 -0500
Message-ID: <ff3b9651-524f-7940-282c-2006857be93b_at_gmail.com>
Replies in-line
On 01/29/2018 10:26 AM, Jared Still wrote:
> Mladen,
>
> Which version of Oracle was this?
Oracle 12.1.0.2
>
> Also, what were some of the crippling bugs?
Bug 17632286 - ORA-600 [qksdsUpdTabStatsCbk:0] when dynamic_sampling=11
(Doc ID 17632286.8)
Patch 20586191: ORA-600 [QESMAGETDOMIDXSEG1] FOR A QUERY WHEN OPTIMIZER_DYNAMIC_SAMPLING = 11 Also there was a problem with latches when parsing.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 30 2018 - 01:47:15 CET