Printable View
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.
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
Normal philosophy is 1/3 of Total RAM, but it could go up...Quote:
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.
LogBuffer normally would be 1K. The other two depends on the shop and its an evolving process. You keep tuning...Quote:
[
2. how much size will i allocate for the Data Buffer Cache? Log Buffer? and Shared Pool Size?
Its again depends on the shop. Normally 5M is optimalQuote:
3. what should be the size of my Redo Log Files in relation to my Redo Log Buffer
Sam
Quote:
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.
Quote:
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.
Quote:
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.
[QUOTE]Originally posted by sambavan
Sorry for the wrong suggestion on Log Buffer. LogBuffer normally would be 1M and not 1KQuote:
Originally posted by D Maverick
LogBuffer normally would be 1K. The other two depends on the shop and its an evolving process. You keep tuning...Quote:
[
2. how much size will i allocate for the Data Buffer Cache? Log Buffer? and Shared Pool Size?
Sam
Sam
Thank you very much Sam & Jeff !
The Maverick