on 09-12-2007 1:43 AM
I need to change the RAM values for the SAP instance and Oracle instance. I gave the memory values in the GUI installation and now I have to reduce it. Someone could helpme?
Best regards
Message was edited by:
Reynaldo Rebolledo Romero
Message was edited by:
Reynaldo Rebolledo Romero
Hi Reyanaldo,
I feel you can change PHYS_MEMSIZE for AIX too.
Regards
Umesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The parameter PHYS_MEMSIZE is valid only in Windows enviroment.
To manage the memory under the AIX environment, suggest you the following parameters:
ES/TABLE : Switches to the alternative implementation of the extended memory (EM). Recommended value is SMH_SEGS.
EM/TOTAL_SIZE_MB : The default setting "262144" as good as cancels the limitation on the extended memory. You can restrict the EM by reducing the parameter value. Ideally, this value should be set to
DB + Instance : Total Available RAM + Swap Space - Memory allocated to Oracle
Instancle only : Total Available RAM + Swap Space
ES/SHM_SEG_SIZE : Size of the AIX system segments (in megabytes). Recommended value is 4096
ES/SHM_PROC_SEG_COUNT : Specifies the number of shared memory segments that are used as shared and privately.
ES/SHM_MAX_PRIV_SEGS : Specifies the number of shared memory segments that are used privately. This parameter must be lower than es/shm_proc_seg_count.
Since you are using Oracle database, use parameter db_cache_size and shared_pool_size to manage the memory on the DB side. Once you reduce these parameters, should monitor the DB performance using transaction ST04 for the Buffer Quality and Pin Ratio. Buffer Quality should be greater then 94% and Pin ration should be more than 97%.
Hope this helps!
Regards
Tanuj
consider observing the Buffer Quality and if it is good, suggest you to decrese the parameter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tanuj,
When I am trying to design a view in ABAP web-dynpro component.
I am not able to see the preview of the view due to insufficient buffer. Please find below the steps to reproduce the error.
Steps:
1.Tcode = SE80.
2. Web dynpro component : HAP_DOCUMENT_BODY
3. Select the view 'VW_BODY_VIEW'
4. After the view is selected, click on the button 'Show/Hide Layout Preview'.
After clicking on this button, I am getting an error ' Export buffer not sufficient. Preview deactivated. -> Note 965337'
We have increased the value the of parameter to rsdb/obj/buffersize :40000
rsdb/obj/max_objects: 20000
But still we get the same error.The OS that we are using is AIX 5.3 & Oracle 10.2
Please suggest us the way so that we can resolve the problem.
Regards
Nilesh
Hi Reynaldo,
You may Proceed for SAP Instance as in my previous reply i.e. with PHYS_MEMSIZE )this is case sensitive).
For Oracle instance:
You can adjust following parameter in INITSID.Ora or SPFILE
1) DB_BLOCK_BUFFERS :
This parameter controls the number of database block buffers in the SGA.
You can calculate the amount of memory that will be consumed with the
following formula:
Buffer size = DB_BLOCK_BUFFERS * DB_BLOCK_SIZE
2) SGA_MAX_SIZE which sets an upper limit for the total size of the SGA
Note: Before Changing the parameters justify yourself about the need of reducing Memory for each instance and also that it may have other effects on system performance.
Award Points if helpful.
Regards
Umesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Reynaldo,
Pls check out Parameter PHYS_MEMSIZE.
E.g. CI with 1 GB main memory, the database uses
400 MB and the application server 600 MB. The value for PHYS_MEMSIZE
should therefore be set manually to 600 in the instance profile.
Regards
Umesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Umesh,
I forgot to mention I'm using AIX_5.3 OS with sap R/3 Enterprise 4.70 Ext set 110 with kernel 6.40. and Oracle 9.2.0.7 DB.
Is there any way to do the memory manage for SAP and Oracle system instances?
Regards
Reynaldo
Message was edited by:
Reynaldo Rebolledo Romero
Message was edited by:
Reynaldo Rebolledo Romero
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.