Ram-Upgrade on the Oracle

[Former Member]

Hello,

just a question about our ram-upgrade.

The central instance is installed on the same server with the database (oracle).

The server have 32 GB RAM but soon will be upgraded to 64 GB RAM ( double).

Furter more, there is a dialog-instance-server with 48 GB RAM (it was later installed).

My question is: Which Oracle parameter(s) should i change so the new 32 GB to be allocated only for the DB ? (think for the sap application there is more than enough - over 20 GB on the first server + 48 on the second).

Servers:

-

---

Central Instance+DB:

SAP ECC 6.0,

OS: RHEL 5.4

DB: Oracle 10.2.0.4

RAM: 32 GB (soon 64 GB)

-

---

Dialog Instance:

SAP ECC 6.0 (dialog),

OS: RHEL 5.4

DB: Oracle 10.2.0.4

RAM: 48 GB

-

---

Thanks a lot in advance!

Best regards,

Aleks

[stefan_koehler]

Hello Aleks,

depending on your linux (bit) version and your current memory settings - please keep the memory overhead of a "larger" SGA in mind. You should use large pages if possible.

http://jonathanlewis.wordpress.com/2010/06/23/memory/

Regards

Stefan

[daniel_lippmann5]

If you haven't set up large pages yet, ask your SAP consultant...

[Former Member]

Hi Aleks,

You should set DB_cache_size parameter, in the profile.

Best regards,

Orkun Gedik

[Former Member]

Hi,

In addition to the note suggested by Sunny, the following discussion helps in understanding the key parameters and views.

Br,

Venky

[Former Member]

Hi Venkatesh,

which discussion do you ment?

Br,

Aleks

[sunny_pahuja2]

Hi,

You can change your SGA size as per new RAM size. And also check SAP note 830576 (assuming you are running on oracle10g) which will give you reference to other notes that help you analyzing bottleneck in your database and accordingly you can change parameters.

Thanks

Sunny