Understanding Oracle traces and plan

Below are few of the excellent notes on execution plans and trace from expert Charles Hooper

http://hoopercharles.wordpress.com/2010/01/30/execution-plans-what-is-the-plan-and-where-do-i-find-it/ (3 part series)
http://hoopercharles.wordpress.com/2009/12/01/10046-extended-sql-trace-interpretation/ (2 part series)
http://hoopercharles.wordpress.com/2010/01/11/explain-plan-lies-autotrace-lies-tkprof-lies-what-is-the-plan/

 

About these ads

Tags: autotrace, explain plan, Oracle Trace, tkprof