Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Estimate temp space

Re: Estimate temp space

From: Mladen Gogala <mgogala.SPAM-ME.NOT_at_verizon.net>
Date: Fri, 6 Apr 2007 01:07:50 +0200 (CEST)
Message-ID: <pan.2007.04.05.23.04.09@verizon.net>


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.com
Received on Thu Apr 05 2007 - 18:07:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US