how to calculate value for DB_BLOCK_BUFFER ?

[hoctro]

Given db_block_buffers = 139005. If I want to add 100MB to this value, how should I calculate for the new value of db_block_buffers?

Thanks

 

[karluk]

You need to know db_block_size to figure this out. Suppose it's 8k. Then increasing db_block_buffers by 128 would add another 8k*128=1024k=1mb to the db buffer cache. For 100mb the increase to db_block_buffers would be 12800. The new value of db_block_buffers would be 139005+12800=151805.

If you have a block size different from 8k you need to go through a similar calculation to figure out the adjustment.

 

[ljspop]

Hi Hoctro,

Divide 100MB by your db_block_size and add that to your current value of db_block_buffers. Database buffer cache size is determined by:

db_block_size * db_block_buffers = (size of db buffer cache)

Bob Bob Lowell
ljspop@yahoo.com