Re: Maximum size for PGA_AGGREGATE_TARGET
From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Tue, 19 Jan 2010 09:24:50 -0300
Message-ID: <172762181001190424j5a1e7ec1p9f91e30e33be29a5_at_mail.gmail.com>
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.
Date: Tue, 19 Jan 2010 09:24:50 -0300
Message-ID: <172762181001190424j5a1e7ec1p9f91e30e33be29a5_at_mail.gmail.com>
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_at_the-playground.de>wrote: [SNIP]
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 19 2010 - 06:24:50 CST