Re: Implementing ADDRESS WINDOWING EXTENSIONS (AWE) for increased memory

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: davidg.oraclel@xxxxxxxx
  • 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@xxxxxxxx> wrote:

> Hi,
>
> 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
> 10.2.0.1.
>
> 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?
>
> Thanks,
> David Grosser
> DBA
> 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

Other related posts: