Re: Estimate temp space

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 05 Apr 2007 14:19:35 -0700
Message-ID: <1175807971.364991@bubbleator.drizzle.com>

Mladen Gogala wrote:
> 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.

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.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Apr 05 2007 - 16:19:35 CDT