Re: Diff between utlxplp.sql and utlxpls.sql ?

Raaj wrote:
>
> Could anyone describe me about difference between utlxplp.sql and
> utlxpls.sql scripts.
>
> Thanks in Advance,
>
> Rajkumar.K

I don't have the software handy, but isn't one explain plan for serial, and explain plan for parallel

Either way

select * from table(dbms_xplan.display)

should be a better option

hth

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------