title: Best Oracle SQL query analyze tool
body: <p>I'm looking for a tool (either free or paid) capable of visualization oracle SQL query performance. </p>
  
  <p>The ultimate goal is to have a tool, that can be easily read (eg. not EXPLAIN PLAN result) and that I can use to detect slow parts of query (eg. what join with what condition is actually adding the most to the whole query cost). I do <strong>not</strong> need automatic query optimization, I just want to see why does a query has too high cost. Also, it is best if the analyzer can run without special privileges.</p>
  
  <p>I've tried Quest SQL Optimizer for Oracle, which looks quite ok, but I'm missing the option to see join conditions (much like SQL Developer). Also, I'm not able to easily find what join takes up most of the query cost.</p>
  
  <p>What are your experiences? Is there a tool for this?</p>