Re: Maximum size for PGA_AGGREGATE_TARGET

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 19 Jan 2010 17:47:47 +0000
Message-ID: <7765c8971001190947sb64eab0la132e764f525c797_at_mail.gmail.com>

On Tue, Jan 19, 2010 at 12:24 PM, Guillermo Alan Bort <cicciuxdba_at_gmail.com>wrote:

> 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 win32 yes, on win64 no - guess which I recommend? <vbg>. In addition you
can't use AWE memory for anything but manually managed buffer cache, so it doesn't directly help with the PGA at all. AWE is just an ugly hack like extended memory was and just as useless. The right solution is 64bit computing.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 19 2010 - 11:47:47 CST