Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Space allocation activity (_ActSpace)
 
Space allocation activity (_ActSpace)
The _ActSpace VST displays space allocation information, including the number of database extends, the number of times a block was used from and returned to the free chain, the number of times space was allocated for a record (from the rm chain or from the free chain) the number of bytes allocated for record fragments, the number of rm blocks examined or removed, the number of blocks added to the front or back of the rm chain, the number of moved blocks, the number of locked chain entries, the number of transactions committed, and database up time.1
Field name
Data type
Description
_Space-AllocNewRm
INT64
Number of times space was allocated for a record or record fragment
_Space-BackAdd
INT64
Number of blocks added to the back of the rm chain
_Space-BytesAlloc
INT64
Number of bytes allocated for record fragments
_Space-DbExd
INT64
Number of times the database was extended
_Space-Examined
INT64
Number of blocks examined in the rm chain while looking for space for a record fragment
_Space-FromFree
INT64
Number of times space was allocated from the free chain
_Space-FromRm
INT64
Number of times space was allocated from the rm chain
_Space-Front2Back
INT64
Number of blocks moved from the front to the back of the rm chain
_Space-FrontAdd
INT64
Number of blocks added to the front of the rm chain
_Space-Locked
INT64
Number of locked rm entries removed
_Space-Removed
INT64
Number of blocks removed from the rm chain
_Space-RetFree
INT64
Number of times a block was returned to the free chain
_Space-TakeFree
INT64
Number of times a block was used from the free chain
_Space-Trans
INT64
Number of transactions committed
_Space-UpTime
INTEGER
Number of seconds the database was up

1 Activity and status of ABL temp-tables is available in this virtual system table. The statistics gathered allow you to monitor the operation and performance of deployed client temp-tables. Specify the range of temp-tables to track with the -ttbasetable and -tttablerangesize startup parameters. Specify temp table indexes with -ttbaseindex and -ttindexrangesize startup parameters. For more information monitoring and debugging temp tables with VSTs, see OpenEdge Development: Debugging and Troubleshooting.