Kbase P19185: What is the formula to calculate how to increase -B?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/10/2003 |
|
Status: Unverified
GOAL:
What is the formula to calculate how to increase -B?
FIX:
-B is the number of blocks in database buffers. The -B multiplied by the database blocksize gives a rough estimate of memory usage for the database.
To determine the efficiency of database buffer activity, check the Buffer Hits
field of the PROMON Activity option. For best performance, increase the Blocks
in Database Buffers (-B) parameter until the buffer hits percentage exceeds 95
percent, or until your system starts paging.