Kbase P117538: How to calculate the memory allocated for the buffer pool hash table.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/07/2006 |
|
Status: Unverified
GOAL:
How to calculate the memory allocated for the buffer pool hash table.
GOAL:
How to use -hash startup parameter to find the memory allocated for the buffer pool hash table.
FIX:
The hash table entries (-hash) startup parameter determines the number of hash table entries to use for the buffer pool. Also, the number of entries in a buffer pool hash table is reported in the database .lg file at startup. Each entry is 4 bytes on 32-bit systems and 8 bytes on 64-bit systems. The total memory allocated for this hash table is the number of entries times the size of each entry.