Hi,

I need to change the db_block_buffers because i have found that the cach hit ratio is far too low.

I have enough memory available on the unix box.

My question is should the db_block_buffer be a multiple of db_block_size.

e.g. my block size is 8192K and my buffer size is 8192K, this gives me about 6mb of space. should i increase buffer size to 16384K(2*db_block_size) as the next figure for db_block_buffer.


look forward to reading the advice.

thanks