Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Summary activity (_ActSummary)
 
Summary activity (_ActSummary)
The _ActSummary VST displays general information about database activity, including the number of transactions committed and rolled back; the number of records read, updated, created, and deleted; the number of record locks and waits; the number of database reads and writes; before-image and after-image information; and buffer information.1
Field name
Data type
Description
_Summary-AiWrites
INT64
Number of AI blocks written to disk
_Summary-BiReads
INT64
Number of BI blocks read
_Summary-BiWrites
INT64
Number of BI blocks written to disk
_Summary-Chkpts
INT64
Number of checkpoints that have been performed
_Summary-Commits
INT64
Number of transactions all users have committed
_Summary-DbAccesses
INT64
Number of times users have waited for shared and exclusive locks on a database buffer
_Summary-DbReads
INT64
Number of database blocks read
_Summary-DbWrites
INT64
Number of database blocks written to disk
_Summary-Flushed
INT64
Number of database buffers that have been flushed to disk because they were not written by the time the checkpoint ended
_Summary-RecCreat
INT64
Number of records created
_Summary-RecDel
INT64
Number of records deleted
_Summary-RecLock
INT64
Number of record locks used
_Summary-RecReads
INT64
Number of records read
_Summary-RecUpd
INT64
Number of records updated
_Summary-RecWait
INT64
Number of times users have waited to access a locked record
_Summary-TransComm
INT64
Number of transactions committed
_Summary-Undos
INT64
Number of transactions rolled back
_Summary-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.