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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Shrinking PGA of snp processes

Re: Shrinking PGA of snp processes

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 13 May 2005 22:00:53 +0100
Message-ID: <028c01c557fe$d9f292b0$0301a8c0@porgand>


Hi Christo,

What's the _smm_max_size value for your session? It states the max workarea size for a serial session in kB (and defaults to 5% of pga_aggregate_target).

But if you want so big PGA memory areas, it might be worth using manual workarea for those sessions anyway...

Tanel.

> Tanel,
>
> I've noticed that the growth of memory is done in steps. And those
> steps become progressivelly large, until it can no longer allocate
> memory.
>
> Even on 64 bit systems, a single workarea is limited to 4 gb. And
> because of this step allocations, allocation actually stops at arround
> 3.5 gb (instead of just under 4gb).
>
> Have you found any way to control the step, or at least the maximum
> step during step allocation ?
>
> I wonder when they will start to support the Linux hugetlb pool for pga
> mem=
> ory.
>
> I've noticed that it will never de-allocate the memory, if you are
> under your pga_aggregate_target. But once you start using it in
> another process, it will de-allocate it.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 13 2005 - 17:05:26 CDT

Original text of this message

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