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

  • From: kathy duret <katpopins21@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 6 Feb 2008 13:43:41 -0800 (PST)

  You might have to get your sga target lower as well.
  I had issues with hyperthreading and the sga target and had to lower my sga 
  Look at your pools - large, java, you might be able to lower those.
  I didn't have great success with /PAE switch but I was on and it had 
memory leaks that supposedly were fixed in
  I used the /3G switch, used orastack and some other tricks to stretch my 
virtual bytes in Windows.

"Koivu, Lisa" <Lisa.Koivu@xxxxxxxxxxxxxx> wrote:
        v\:* {behavior:url(#default#VML);}  o\:* {behavior:url(#default#VML);}  
w\:* {behavior:url(#default#VML);}  .shape {behavior:url(#default#VML);}        
        Hi David, 
  If you?ve tried to bring the database up once and received this error, you 
will need to reboot the host to clear out memory.  Set the db service to not 
start upon reboot so you can control the restart when the host is back. 
  Ensure that your settings are not too large for the amount of memory you have 
available also.  Remember, db_block_buffers is the number of blocks, not the 
size of the pool.  That?s bit me more than once. 
  Good luck.  
  From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of David Grosser
Sent: Friday, February 01, 2008 4:23 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Implementing ADDRESS WINDOWING EXTENSIONS (AWE) for increased memory

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 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®-get your 
"fix". Check it out.

This electronic message transmission contains information from the Company that 
may be proprietary, confidential and/or privileged. The information is intended 
only for the use of the individual(s) or entity named above. If you are not the 
intended recipient, be aware that any disclosure, copying or distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic transmission in error, please notify the sender immediately by 
replying to the address listed in the "From:" field. 

Looking for last minute shopping deals?  Find them fast with Yahoo! Search.

Other related posts: