cancel
Showing results for 
Search instead for 
Did you mean: 

RAM Doubled

Former Member
0 Kudos

Dear All,

shar

We have an ECC6 server on windows 64 bit oracle which was running on 12 gb of RAM

Now we have upgraded to 24 GB of RAM.

Which all parameters need to be changed at oracle and SAP level for this.

Please update

Regards

Sandeep

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi,

As a rule use a 60-40 ratio between SAP memory and Oracle memory. In your case that would be roughly 14 GB SAP and 10 GB Oracle. In most cases Oracle does not really need that much memory, so in your place I would give SAP a bit more. As mentioned in an earlier reply, with Windows you use zero-administration memory management, which means in practice that you set only one profile parameter for memory sizing, i.e. PHYS_MEMSIZE. On the Oracle side the main parameters that control memory allocation are db_cache_size, shared_pool_size and pga_aggregate_target. Usually I also set sga_max_size to a value larger than the sum of DB cache + shared pool, so that there is space to tweak the buffer sizes dynamically without having to stop the DB.

If I had to configure your machine then these would probably be my starting values:

SAP =>
PHYS_MEMSIZE = 16384   # 16 GB

Oracle =>
db_cache_size = 3500M
shared_pool_size = 700M
pga_aggregate_target = 2G
sga_max_size = 6G

Regards,

Mark

Former Member
0 Kudos

You can try to run Automated Oracle DB parameter check as per following note

Note 1171650 - Automated Oracle DB parameter check

Former Member
0 Kudos

HI,

Former Member
0 Kudos

As you are on Windows, you need read about Zero AMM -->

Note 88416 - Zero administration memory management as of 4.0A/ Windows

Regards.

Former Member
0 Kudos

Hi,

Go through SAP note 830576 & 146289.

Regards,

Sachin Rane.