Nenad Noveljic| All-round Database Topics
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 → The post Performance Improvement on Dictionary Views in Oracle 21c appeared first on All-round Database Topics.| All-round Database Topics
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 → The post Bind Variable Length in PL/SQL, C, Java and Python appeared first on All-round Database Topics.| All-round Database Topics
Workarounds provided Continue Reading → The post ORA-07445 [__intel_avx_rep_memcpy()] During a Rowset Operation appeared first on All-round Database Topics.| All-round Database Topics
An error in the make file with an easy fix. Continue Reading → The post OCI Demo Linking Error appeared first on All-round Database Topics.| All-round Database Topics
Analysis of dataset properties leading to a bad performance problem with a simple fix. Continue Reading → The post A Data Model Fix for Suboptimal Semi-Join and Anti-Join Cardinality Estimates appeared first on All-round Database Topics.| All-round Database Topics
A boundary condition where subpartition statistics gathering can also trigger partition statistics Continue Reading → The post Undocumented Implicit Partition Statistics Gathering appeared first on All-round Database Topics.| All-round Database Topics
Tracing TFA to find out how to change user under under which OSWatcher ist started. Continue Reading → The post Changing OSWatcher User appeared first on All-round Database Topics.| All-round Database Topics