on 10-01-2009 8:04 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can try to run Automated Oracle DB parameter check as per following note
Note 1171650 - Automated Oracle DB parameter check
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As you are on Windows, you need read about Zero AMM -->
Note 88416 - Zero administration memory management as of 4.0A/ Windows
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Go through SAP note 830576 & 146289.
Regards,
Sachin Rane.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.