Collecting table privileges in PostgreSQL
Collecting privileges under a low-privileged user Continue Reading
Author: Nenad Noveljic
Performance Improvement on Dictionary Views in Oracle 21c
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
Bind Variable Length in PL/SQL, C, Java and Python
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
ORA-07445 [__intel_avx_rep_memcpy()] During a Rowset Operation
Workarounds provided Continue Reading
OCI Demo Linking Error
An error in the make file with an easy fix. Continue Reading
A Data Model Fix for Suboptimal Semi-Join and Anti-Join Cardinality Estimates
Analysis of dataset properties leading to a bad performance problem with a simple fix. Continue Reading
Undocumented Implicit Partition Statistics Gathering
A boundary condition where subpartition statistics gathering can also trigger partition statistics Continue Reading
Changing OSWatcher User
Tracing TFA to find out how to change user under under which OSWatcher ist started. Continue Reading
Troubleshooting TFA Start
A server crash can prevent a correct TFA start. Continue Reading
Kernel Memory Leak due to ACFS Snapshots
The case study of troubleshooting a serious kernel memory leak issue caused by a failed ACFS snapshot deletion. Continue Reading