Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Explain Plan

Re: Explain Plan

From: Bagieta <user_at_example.net>
Date: Thu, 10 Feb 2005 19:21:50 +0100
Message-ID: <cug87a$ii1$1@news.onet.pl>


Or better find some software that helps you to read that execution plan.

> In *general* you read inside out with the results of the inner operation
> providing the input rowset for the outer operation. If you are running
> TKPROF with the explain= parameter don't, the plans it gives are those
> that would be executed if the statement ran now in the environment as it
> is now for the user you use to explain it. The only way to get the plan
> that actually was executed is to use the STAT lines (which is what
> tkprof does if you don't use explain= ) in the trace file or to query
> v$sql_plan if you have that view in the version you are running.
Received on Thu Feb 10 2005 - 12:21:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US