memory/buffer parameters

[former_member233385]

Hi Basis Expert,

What are all the ideal parameters required for memory configuration & buffer/size configuration.

I have an SAP system with 50GB memory.

Is there any fixed formula for tuning the memory/buffer parameters.

Our OS is Sun Solaris 5.10

DB is oracle 11g (11.2.0.2)

Regards,

Anil Shenoy

[former_member191911]

Hi Anil,

On the CI you should give as much as possible memory to the Oracle cache and process at least as possible user load on the CI (so keep it out of the logon group)

The customer where I'm now has the following setup:

CI: 500GB physical memory

Oracle database cache size: 415GB

SAP extended memory: 65GB

Unix: 20GB

App servers: 60GB physical memory

SAP extended memory: 40GB

Unix 20GB

Just make sure that you configure your system in a way to avoid paging on OS level at all times.

Kind regards,

Mark

[former_member233385]

Hi All,

Rightnow am having , my SAP system has exyended memory of   50GB.Let me know what values for the below parameters are sufficient for the system

Table definition buffer TTAB
rsdb/ntab/entrycount

Field description buffer FTAB
rsdb/ntab/ftabsize  
rsdb/ntab/entrycount

Initial record buffer IRBD
rsdb/ntab/irbdsize  
rsdb/ntab/entrycount

Program buffer PXA
abap/buffersize
abap/pxa 

     
CUA buffer CUA
rsdb/cua/buffersize

Screen buffer PRES
zcsa/presentation_buffer_area
sap/bufdir_entries 

Generic key table buffer TABL
zcsa/table_buffer_area
zcsa/db_max_buftab   

Single record table buffer TABLP
rtbb/buffer_length
rtbb/max_tables   

Export/import buffer EIBUF
rsdb/obj/buffersize       
rsdb/obj/max_objects      
rsdb/obj/large_object_size
rsdb/obj/mutex_n        

Regards

Anil     

[former_member191911]

It's impossible to provide these values. It highly depends on the way the system is being used.

When you check ST02, do you see huge amounts of swaps on certain buffers? If that's the case, you could consider increasing these buffers, staying within the available extended memory.

Especially high paging rate on the program buffer and table buffer affect the response time in a negative way.

Kr. Mark