Monthly Archives: April 2014

Oracle 10053 trace viewer

Posted on April 2, 2014 by rlockard

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 http://method-r.com/store . But the 10053 … Continue reading →

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

A quick reference to Outer joins

Posted on April 2, 2014 by rlockard

  I frequently have to stop and think what side the (+) goes on for outer joins.  I found this graphic originally from: http://oakweb02.oaktable.net/node/6628

Posted in Database Stuff | Leave a comment