Again I. Now, I want to know any document where explain me the settings of oracle parameters respect to memory for a system SAP R/3. For instance, for the value of db_block_buffers, the shared_pool_size and the log_buffers.
I am trying setting the parameters for our oracle database to tuning our system.
Thanks for your help.
03-12-2001, 11:20 AM
Configuring SGA depends upon available Physical Memory.
How much does the machine have?
03-12-2001, 11:51 AM
We have 8 GB on the central database instance and we have 3 applications servers. The SAP documentation say me that I must to use the 0.8*RAM for the SGA and the rest for SAP work processes
03-12-2001, 12:16 PM
80 % of RAM for SGA is too big and may not be optimal also. You can start with 2GB and slowly increase so that the HIT Ratio is around 90%. Also remember that RAM is needed for other processes, user sessions and PGA.
03-12-2001, 01:08 PM
How can I distribute the 2 GB for all of the SGA?
03-12-2001, 01:44 PM
In Oracle ERP would be 1.5 shared pool size and .5 db_block_buffers, but that's because Oracle Apps. use a lot of PL/SQL.
If this is not your case you can set it the other way .5G shared pool and 1.5 db_block.
I have been told that log_buffer >=20M doesn't give you any performance.