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.
Depending on how many users are involved, I typically like to keep below 60% of physical RAM. 40% is pretty good if you have alot ( >100) concurrent users with dedicated connections.
2. how much size will i allocate for the Data Buffer Cache? Log Buffer? and Shared Pool Size?
Depends on the application. Typically, I like to start off with 64M shared_pool, 64M large_pool, and 64M of db_block_buffers and then I tune from there.
3. what should be the size of my Redo Log Files in relation to my Redo Log Buffer
Again, depends on the app. A really large log_buffer will not give you tremendous performance gains. I like to start off my log buffer at about 1M and adjust up or down depending on activity. My typical redo-log is 16M but can go up to 128 depending on log switch frequency.