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.




Reply With Quote