Re: Adjust AWE_WINDOW_MEMORY value

> My job is very simple:
> 1. someone did buy any computer with 8GB, did choose
> windows 2003 and Oracle to runnig SAP R/3.
> 2. I must do the best to use correctly those gigabytes of RAM. Then I
> will see if this 'More GB RAM' is better for Oracle and SAP R/3.
>

Just because you have 8Gb of RAM in the server, it doesn't mean you need to use it all....

Bear in mind that the memory above 4Gb can only be used for the Buffer Cache.

Having an SGA which is too big can actually hurt performance.

Access to memory above the 4Gb mark will effectively be accessed via a 'soft' page fault. While this is quicker than disk I/O it is still an overhead (cpu etc).

I would seriously investigate whether you need such a huge SGA...

Matt Received on Mon Oct 31 2005 - 07:51:27 CST