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.

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.