Re: Upgrading with no patches in the "base"?

On Fri, 2021-01-08 at 18:25 +0300, Sayan Malakshinov wrote:
> > Last but not least, why not 19c? 
>
> BTW, interesting idea for a big poll:
> Where did you get more bugs: 11.2, 12.2 or 19.3+

I don't have the exact data and I doubt that anyone outside of Oracle Support organization has the exact data. However, my gut feeling is that 12.2 was by far the buggiest of the listed versions. If you want, I can invent some numbers to confirm my gut feeling, which is a rather common and accepted statistic method. 83.7% of all statisticians say so. BTW, Oracle also supports that scientific method with DBMS_STATS.SET_TABLE_STATS and DBMS_STATS.SET_INDEX_STATS. I used DBMS_STATS.SET_INDEX_STATS to set clustering factor much lower and thereby resolve  the "wrong index" problem. -- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

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