Hi Guys,

I would like to ask your advice on configuring my Oracle Server's SGA size (for OLTP). 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.

2. how much size will i allocate for the Data Buffer Cache? Log Buffer? and Shared Pool Size?

3. what should be the size of my Redo Log Files in relation to my Redo Log Buffer

I hope you guys can help me out. Thanks

The Maverick