Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Other activity (_ActOther)
 
Other activity (_ActOther)
The _ActOther VST displays information about miscellaneous activity, including the number of commits, undo operations, semaphore waits, master block flushes, and database up time.1
Field name
Data type
Description
_Other-Commit
INT64
Number of transactions committed
_Other-FlushMblk
INT64
Number of times the database master block was written to disk
_Other-NBWait
INT64
Number of non-blocking waits for remote clients
_Other-SemLatWait
INT64
Number of semaphore latch waits
_Other-Trans
INT64
Transactions committed
_Other-Undo
INT64
Number of transactions rolled back
_Other-UpTime
INTEGER
Number of seconds the database was up
_Other-Wait
INT64
Number of times a process had to wait for a resource

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.