Kbase P25245: What does "DB Reqst" value means?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/15/2003 |
|
Status: Unverified
GOAL:
What does "DB Reqst" value means?
FIX:
It represents the number of times the database buffer system was searched to find a block. The buffer system is searched every time a process attempts to access a record. If the block that holds the desired record is already in memory, a disk read is not required. If the ratio of DB Reqst to DB Read is not high (10 to 1
or greater), consider raising the value of the Blocks in Database Buffers (-B) startup parameter.
Regardless of the number of available buffers, random record access causes a lower database request to disk read ratio than sequential record access.