Try OpenEdge Now
skip to main content
Database Administration
Reference : PROMON Utility : R&D Activity Displays : Space Allocation
 
Space Allocation
Displays information about Space Allocation.

PROMON Space Allocation Activity display

The following shows a sample Space Allocation Activity display.
09/26/03         Activity: Space Allocation
14:52:41         from 09/25/03 13:56 to 09/26/03 11:23 (for 21 hrs 27 min)

                               Total      Per Min    Per Sec    Per Tx
Database extends               57         0          0.03       0.04
Take free block                13         0          0.00       0.01
Return free block              44         0          0.02       0.03
Alloc rm space                 13         0          0.00       0.00
Alloc from rm                  0          0          0.00       0.05
Alloc from free                70         0          0.04       0.05
Bytes allocated                3          0          0.00       0.00
rm blocks examined             0          0          0.00       0.00
Remove from rm                 3          0          0.00       0.00
Add to rm, front               131        0          0.08       0.10
Add to rm, back                0          0          0.00       0.00
Move rm front to back          134        0          0.08       0.11
Removed locked rm entry        0          0          0.00       0.00
The display lists the following operations:
*Database extends — The number of times the database was extended
*Take free block — The number of times a block was used from the free chain
*Return free block — The number of times a block was returned to the free chain
*Alloc rm space — The number of times space was allocated for a record or record fragment
*Alloc from rm — The number of times space was allocated from the rm chain
*Alloc from free — The number of times space was allocated from the free chain
*Bytes allocated — The number of bytes allocated for record fragments
*rm blocks examined — The number of blocks examined in the rm chain while looking for space for a record fragment
*Remove from rm — The number of blocks removed from the rm chain
*Add to rm, front — The number of blocks added to the front of the rm chain
*Add to rm, back — The number of blocks added to the back of the rm chain
*Move rm front to back — The number of blocks moved from the front to the back of the rm chain
*Remove locked rm entry — The number of rm chain entries that were locked