-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|