Re: Maximum size for PGA_AGGREGATE_TARGET

From: Guillermo Alan Bort <>
Date: Tue, 19 Jan 2010 09:24:50 -0300
Message-ID: <>

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.


On Tue, Jan 19, 2010 at 8:57 AM, Martin Bach <>wrote: [SNIP]

Received on Tue Jan 19 2010 - 06:24:50 CST

Original text of this message