Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: explain plan from pl/sql ?
Explain plan itself won't work from PL/SQL. But turn on tracing for
your session, run your PL/SQL, run tkprof on the trace file and you
should see the exec plan there.
Daniel
> is it possible to run "explain plan" command within a PL/SQL block ?
>
> thanks,
> i.d.
Received on Wed Nov 05 2003 - 15:45:08 CST