RE: Stepping through the SQL Execution plan [was: WTB: Oracle Visual SQL Debugger]

As there seems to be some interest in this topic I wrote a little note about using DTrace for tracing SQL execution plan flow:  

http://blog.tanelpoder.com/2009/04/24/tracing-oracle-sql-plan-execution-with -dtrace/  

It's important to undestand how exactly SQL is executed for troubleshooting cases where optimizer just doesn't get it right. The rows aren't magically produced somehow, plan execution is just a loop, it's a very procedural and structurized approach and we need to get the loop order right.  

I demo this stuff at my seminar too...  

--

Tanel Poder
http://blog.tanelpoder.com  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Charles Schultz
Sent: 24 April 2009 05:21
To: Wolfgang Breitling; Bobak, Mark
Cc: Oracle-L Freelists
Subject: Re: Stepping through the SQL Execution plan [was: WTB: Oracle Visual SQL Debugger]

Hmm.... two responses with exactly the same link... I am getting a message here. =)

Thanks Wolfgang and Mark. Yes, Tanel's paper is awesome! Now I want to go sit in on his Advanced Troubleshooting seminars. *grin*

Ok, I'll settle back and start reading some more. This is good stuff.

On Thu, Apr 23, 2009 at 16:16, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:

How about Tanel (Poder)'s os_explain:

http://blog.tanelpoder.com/2008/06/15/advanced-oracle-troubleshooting-guide- part-6-understanding-oracle-execution-plans-with-os_explain/

At 02:54 PM 4/23/2009, Charles Schultz wrote:

--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 24 2009 - 05:56:09 CDT