Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : User table activity (_UserTableStat)
 
User table activity (_UserTableStat)
The _UserTableStat VST displays statistics on the number of accesses to a specific range of tables by user.1
Field name
Data type
Description
_UserTableStat-Conn
INTEGER
User number
_UserTableStat-Num
INTEGER
Table number
_UserTableStat-create
INT64
Number of times create access has occurred to the table by the specified user
_UserTableStat-delete
INT64
Number of times delete access has occurred to the table by the specified user
_UserTableStat-PartitionId
INTEGER
Partition Id of the user
_UserTableStat-read
INT64
Number of times delete access has occurred to the table by the specified user
_UserTableStat-TenantId
INTEGER
Tenant Id of the user
_UserTableStat-update
INT64
Updates the table
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.