Enriching Trace with Call Stacks
A DTrace script for capturing the call stack when a line gets written into the trace file. It’s useful, for example, for finding out the functions participating in a particular query transformation. Continue Reading
Month: December 2018
Suboptimal Execution Plan with Join Predicate Push-Down Transformation
JPPD is performed where it shouldn’t. Use the CBO trace parser for detecting the problem. Continue Reading
Dissecting Cost Based OR-Expansion
Analyzing the CBO trace for getting insight into the cost based OR-expansion Continue Reading