Re: Tkprof output question

"wagen" <wagen123_at_yahoo.com> wrote in message news:c83c8fbf.0411250847.5183efcf_at_posting.google.com...
> Use explain plan to determine the execution plan.

I've alluded to this in my other answer.

explain plan (which is what explain= does) determines what the execution plan *would be* now. This can be, and sometimes is, different from the actual plan that the particular process being traced used. There are of course a variety of reasons for this, stats might have changed - the objects involved might have changed, the statement might have aged out and is being reparsed with different bind variables than the original, session state might be different and so on. The bottom line though is that there is only one place in which the *actual* execution plan is recorded and that is a trace file.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com