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: Thu, 5 Apr 2007 22:58:52 +0200 (CEST)
Message-ID: <pan.2007.04.05.20.55.10@verizon.net> 





On Thu, 05 Apr 2007 22:29:58 +0200, astalavista wrote:



> Hi,

> 

> Is it possible for query to estimate its temp consumption ?

> 




No, because the temp consuption doesn't depend only on a query.
It also depends on PGA, whether you're using manual or automatic
PGA allocation, how much memory is available for allocation, in case
you're doing automatic PGA, to say only the few.


-- 
http://www.mladen-gogala.com


Received on Thu Apr 05 2007 - 15:58:52 CDT












Original text of this message













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