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