db_block_buffers size

[sajeev]

Hi,
I've analysed the statspack report with a tool and it had given a suggesion to increase the size of the db_block_buffers from 5000 to 100,000(20 times). How do we calculate thesize of the db_block_buffers parameter normally and what should be the value of it.
Thanks & Regards

[gandolf989]

db_block_buffer*block_size=total block buffers in bytes
The value depends on the system, how much data you have and how you pull that data out of the database. Make sure that the total sga is equal to or less than 60-70% of your total ram, depending on what else is running on your server. If your server runs a lot of other software etc. Try increasing the block buffers in stages and monitor performance in between.

[vastdba]

At the time of increasing the Block Buffers is it not possible in incrementing the SGA size too?

VAST

[chao_ping]

Originally posted by vastdba
At the time of increasing the Block Buffers is it not possible in incrementing the SGA size too?

VAST

Don't you know the data buffer is the largest part of the sga size?

[vastdba]

Originally posted by chao_ping
Don't you know the data buffer is the largest part of the sga size?

If you carefully look into my posting I made endorsed to the statement keeping in view the least you have suggested to me.
BUT
I made it as automatically it increments the overall size.



VAST

[SANJAY_G]

Originally posted by vastdba
If you carefully look into my posting I made endorsed to the statement keeping in view the least you have suggested to me.
BUT
I made it as automatically it increments the overall size.



VAST

Vast, Sorry to say this after reading few of your post.
It is not necessary to reply each and every post on the forum without making any sence. It further confuses the person looking for a solution. Please, post the helping answers only.