Monthly Archives: April 2014

Oracle 10053 trace viewer

There are two trace files that I use when tuning.  Cary Millsap @CaryMillsap and Method-R @MethodR have a great tool for analyzing the 10046 trace file. There is the profiler and my personal favorite mrskew . But the 10053 … Continue reading

Posted in Cost Based Optimizer, Database Stuff | Tagged | Leave a comment

A quick reference to Outer joins

  I frequently have to stop and think what side the (+) goes on for outer joins.  I found this graphic originally from:

Posted in Database Stuff | Leave a comment