title: SQL tuning in Oracle
body: <p>Is there any article/link available where I can find examples of SQL tuning(Oracle). It would great if it is explain with example. I need something like existing query, statstics, plan and then suggested query/recommendation and new plan.</p>
  
  <p>I found couple of really good links on google:</p>
  
  <ol>
  <li><a href="http://www.dba-oracle.com/art_sql_tune.htm" rel="nofollow noreferrer">http://www.dba-oracle.com/art_sql_tune.htm</a></li>
  <li><a href="http://www.orafaq.com/tuningguide/" rel="nofollow noreferrer">http://www.orafaq.com/tuningguide/</a></li>
  </ol>
  
  <p>However I m looking for real time examples with above mentioned details, which are missing in these articles.  </p>
  
  <p>I hope I m not asking for too much. :-)</p>