Re: Implementing ADDRESS WINDOWING EXTENSIONS (AWE) for increased memory
Date: Wed, 6 Feb 2008 14:44:19 -0800
From the ML Note:
The size of this window is defined by a registry setting in the HOME key for
Oracle (HKLM\Software\Oracle\Homex) called AWE_WINDOW_MEMORY. By default, this value is 1GB, so if this value is not set in the registry, AWE_WINDOW_MEMORY will be 1GB.
This is set on a per instance basis.
On Feb 1, 2008 1:22 PM, David Grosser <davidg.oraclel_at_live.com> wrote:
> I'm trying to implement ADDRESS WINDOWING EXTENSIONS (AWE) to take
> advantage of all of the memory on my server. The server details are:
> Windows server 2003 enterprise edition, 4 processors, 8 GB memory, Oracle
> I tried to implement awe according to metalink note *225349.1 *but my
> instance is not coming up. I did the following:
> - added switches /PAE and /3GB to the boot.ini
> - removed sga_target from the spfile
> added USE_INDIRECT_DATA_BUFFERS=TRUE to the spfile
> - added DB_BLOCK_BUFFERS to the spfile
> The error I get when I start the database is :
> ORA-27102: out of memory
> OSD-00034: additional error information
> O/S-Error: (OS 8) Not enough storage is available to process this command.
> I've tried raising and lowering the memory but nothing works.
> Has anyone implemented AWE? If so, how did you get it to work?
> David Grosser
> NSTAR Electric and Gas
> Need to know the score, the latest news, or you need your Hotmail(R)-get
> your "fix". Check it out. <http://www.msnmobilefix.com/Default.aspx>
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 06 2008 - 16:44:19 CST