Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tkprof output question
Niall Litchfield wrote:
> "wagen" <wagen123_at_yahoo.com> wrote in message
> news:c83c8fbf.0411250847.5183efcf_at_posting.google.com...
>
>>Use explain plan to determine the execution plan.
Except in 9i and above, where v$sql_plan will show you the real plan, as it was genuinely parsed and executed, assuming it's still in the Library Cache, of course.
But that's trivia. It's an important point that you make that "explain plan for" shows you what would happen, not what has happened. Thanks for mentioning it.
Regards
HJR
Received on Thu Nov 25 2004 - 17:31:30 CST