Kbase P86161: What does DB Reqst Column in PROMON means
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/28/2004 |
|
Status: Unverified
GOAL:
What does DB Reqst Column in PROMON means
FIX:
PROMON Locking and Waiting Statistics Option
Block Access:
DB DB DB BI BI AI AI
Type Usr Name Reqst Read Write Read Write Read Write
Acc 999 TOTAL... 17393 1866 424 321 989 204 444
Acc 0 102 102 34 23 75 12 48
Acc 1 sue 6060 876 144 165 304 75 128
Acc 2 dave 4023 654 185 78 406 34 156
Acc 3 86 84 8 12 22 9 18
Acc 4 mary 3454 6 13 7 46 3 6
Acc 5 bill 3726 235 58 43 128 28 71
Acc 6 0 0 0 0 0 0 0
RETURN - repeat, U - continue uninterrupted, Q - quit:
DB Reqst
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.