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: workarea_size_policy being ignored

Re: workarea_size_policy being ignored

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 23 Dec 2004 03:29:26 +1100
Message-ID: <41c9a0ee$0$1078$afc38c87@news.optusnet.com.au>


Tom wrote:
> We do use a lot of procedure and package calls, and it could be the
> nature of the benchmark execution that results in memory not being
> freed up. But I thought that sort_area_size limits the amount of
> memory for a connection. In fact, Metalink Note 30918.1 specifically
> states that "Multiple allocations never occur. Only one memory area of
> SORT_AREA_SIZE exists for each user process at any time."
>
> Tom
>

Crikey! That's definitely wrong. A single piece of SQL may require multiple sorts, but Oracle hard limits that to no more than two concurrent allocations of sort area size. But it's definitely not limited to one.

And if you start parallelising your SQL, off the top of my head I seem to recall that you will start consuming 2 * the number of sorts greater than 2 * the degree of parallelism of sort_area_retained_size, too.

Metalink needs fixing, methinks...

Regards
HJR Received on Wed Dec 22 2004 - 10:29:26 CST

Original text of this message

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