Andi SchloeglDisadvantages of new Real Time SQL Monitors and how to convert them backWhen I first saw the new version/design of Oracle‘s Real Time SQL Monitors, I was pretty excited to see that they no longer require Flash…Jul 30, 2020Jul 30, 2020
Andi SchloeglJoin Elimination PitfallsThis post is just a short note to show different behaviour in Join Elimination between Oracle 12.1 and 19.3 when dealing with deferrable…Jul 3, 2020Jul 3, 2020
Andi SchloeglLong Parse due to Skew Detection in Hybrid Hash DistributionTo get a detailed overview how Skew Detection in Hybrid Hash Distributions works, Randolf Geist has written a very good article on it…Apr 20, 2020Apr 20, 2020
Andi Schloeglarrrrgh UNIQUELast week I faced two glitches in Oracle’s CBO regarding cardinality/selectivity estimations which I want to share here. This post is…Mar 11, 2019Mar 11, 2019