Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: explain plan from pl/sql ?
Andy Hassall wrote:
>On Fri, 07 Nov 2003 09:24:49 -0800, Daniel Morgan <damorgan_at_x.washington.edu>
>wrote:
>
>
>
>>Oracle has already published statements that the DBMS_XPLAN built-in
>>package should
>>be used rather than Explain Plan. Why the discussion of something Oracle
>>has advised be
>>dropped?
>>
>>
>
> Could you provide references to those statements? DBMS_XPLAN's DISPLAY
>function is very useful, but it's only for formatting the results of an EXPLAIN
>PLAN statement previously generated into a plan table. How can EXPLAIN PLAN be
>deprecated in favour of DBMS_XPLAN if there's no way of generating a plan with
>it?
>
>--
>Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
>Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
>
>
You are correct. I should have been clearer in my answer. I've no
excuse. Was tired and rushing.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri Nov 07 2003 - 17:00:23 CST