Re: Maximum size for PGA_AGGREGATE_TARGET

From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>

To: development@xxxxxxxxxxxxxxxxx

Date: Tue, 19 Jan 2010 09:24:50 -0300

Just a thought, but PGA_AGGREGATE_TARGET is the *target* (not a hard limit)
for the maximum memory allocated in PGA, that is the sum of each process'
PGA This being the case, and having the 1.7G limit in most 32bit linux
kernel (not sure in other unix system) you are only limited by this in each
process. AFAIK PGA cannot use hugepages.
On the other hand, on windows, you are limited to 2G on the ENTIRE oracle
process that is PGA + SGA, unless PAE/AWE is used.
hth
Alan.-
On Tue, Jan 19, 2010 at 8:57 AM, Martin Bach
<development@xxxxxxxxxxxxxxxxx>wrote:
[SNIP]