Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Estimate temp space
On Thu, 05 Apr 2007 14:19:35 -0700, DA Morgan wrote:
> Try this:
>
> explain plan for select source from sys.source$ order by source; set
> linesize 121
> select * from table(dbms_xplan.display);
>
> I think you'll change your mind.
You are right, I stand corrected. Thanks.
-- http://www.mladen-gogala.comReceived on Thu Apr 05 2007 - 18:07:50 CDT
![]() |
![]() |