Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Record activity (_ActRecord)
 
Record activity (_ActRecord)
The _ActRecord VST displays record activity information, including the number of bytes created, deleted, read, and updated; the number of fragments created, deleted, read, and updated; the number of records created, deleted, read, and updated; the number of transactions committed; and database up time.1
Field name
Data type
Description
_Record-BytesCreat
INT64
Number of bytes created
_Record-BytesDel
INT64
Number of bytes deleted
_Record-BytesRead
INT64
Number of bytes read
_Record-BytesUpd
INT64
Number of bytes updated
_Record-FragCreat
INT64
Number of fragments created
_Record-FragDel
INT64
Number of fragments deleted
_Record-FragRead
INT64
Number of fragments read
_Record-FragUpd
INT64
Number of fragments updated
_Record-RecCreat
INT64
Number of records created
_Record-RecDel
INT64
Number of records deleted
_Record-RecRead
INT64
Number of records read
_Record-RecUpd
INT64
Number of records updated
_Record-Trans
INT64
Number of transactions committed
_Record-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.