Oracle’s heuristics previously avoided considering fixed tables for Join Predicate Pushdown (JPPD) transformation, leading to suboptimal plans. Enforcing predicate pushing into the view with the PUSH_PRED hint was a workaround. Oracle addressed this in the 21c release, evaluating fixed tables for JPPD. Continue Reading
PL/SQL, C, Python and Java handle bind variable length differently. As a consequence, different execution plans could be generated when the same query runs from different programming languages.
Continue Reading
Workarounds provided Continue Reading
An error in the make file with an easy fix. Continue Reading
Analysis of dataset properties leading to a bad performance problem with a simple fix. Continue Reading
A boundary condition where subpartition statistics gathering can also trigger partition statistics Continue Reading
Tracing TFA to find out how to change user under under which OSWatcher ist started. Continue Reading
A server crash can prevent a correct TFA start. Continue Reading
The case study of troubleshooting a serious kernel memory leak issue caused by a failed ACFS snapshot deletion. Continue Reading
Check your /proc/slabinfo permissions if your Oracle OSWatcher isn’t running under root. Continue Reading