Changing DB_BLOCK_SIZE

Greetings, folks. We are running Oracle on a SUN 6/670, and are involved in doing some application and platform performance testing. We would like to tune Oracle up as best we can before beginning tests.

My question has to do with DB_BLOCK_SIZE. Currently, it is set at the default for SUN, 2K. In speaking with the application vendor about optimizing our site, I have been advised to, among other things, increase the block size to 8192. Also, to increase DB_BLOCK_BUFFERS to 8192.

The main reason for considering the block size change is that previous tests seem to indicate that a 12 user load is about the limit for this particular application on this platform.

I have also been told before (not by this vendor) not to fool with the block size. Sooooooo, I would appreciate any words of wisdom the sages of netland might have--- Pros and cons.

You can email me --- dbsgrm_at_Arco.COM, or post to the net.

Thanks in advance for the help.

Gary Meyers (214)754-4191
dbsgrm_at_Arco.Com

-- 


*    Gary Meyers        gary.meyers_at_merlin.edm.arco.com

*  ARCO Exploration &     


*  Production Technology