Originally posted by D Maverick
Hi Guys,

I would like to ask your advice on configuring my Oracle Server's SGA size. I have a machine with 512MB of RAM running WindowsNT

1. how much memory must i allocate for the SGA? currently its about 40% of the total RAM.
Normal philosophy is 1/3 of Total RAM, but it could go up...

[
2. how much size will i allocate for the Data Buffer Cache? Log Buffer? and Shared Pool Size?
LogBuffer normally would be 1K. The other two depends on the shop and its an evolving process. You keep tuning...


3. what should be the size of my Redo Log Files in relation to my Redo Log Buffer
Its again depends on the shop. Normally 5M is optimal


Sam