RE: Using Windows Extension/adding memory to Oracle

Be sure you know what you want to increase. I spent of fair amount of time playing with this before understanding that AWE allows you to increase ONLY db_block_buffers (ie - move those out of the default 3gb address space). It's in the docs/notes, I just repeatedly missed it.

It will not allow you to increase, say, the size of shared_pool_size or large_pool_size beyond the 3gb limit (along with the rest of the SGA). For that, you need to go to a 64-bit architecture.

-joe
http://www.peaceaday.com

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of J. Dex
> Sent: Monday, August 14, 2006 1:37 PM
> To: oracle-l_at_freelists.org
> Subject: Using Windows Extension/adding memory to Oracle
>
> Anything to watch out for when implementing PAE/AWE and 3GB switch on
> Windows 2003 in order to give more memory to Oracle?
>
> When I look under AWE_WINDOW_MEMORY, I do not see any settings for it.
> Does
> that mean it is the default value of 1GB?
>
> I have a Windows 2003 Server with 8GB memory that has five 9.2.0.7
> databases
> running on it. I want to extend the memory to take advantage of the
8GB.
> PAE is already turned on.
>
> My understanding of how to do this is:
> 1. Add /3GB /PAE to boot.ini file
> 2. Make sure LocalSystem account has the privilege to Lock Pages in
> Memory
> and that the OracleService<SID> starts as LocalSystem account.
> 3. Set USE_INDIRECT_DATA_BUFFERS=TRUE in spfile of each instance.
> 4. Change DB_CACHE_SIZE to use DB_BLOCK_BUFFERS instead.
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's
FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>

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