Monitor Users of a Table (8)
To monitor users of a table, you must first set the table name (9).
|ProTop RT Label||Alertable Metric*||Description|
|Usr#||usrNum||Unique user number reference used by Progress schema tables|
|User Name||UsrName||User name associated with the Usr#|
|Churn||tblTurn||The ratio of record reads to the number of records in that table. For instance, a table with 100 records read 1000 times per second would have a churn of 10. This does not necessarily mean that “table scans” are taking place – it could just as easily be a single record read over and over and over.|
|Create||tblCr||Number of records created|
|Read||tblRd||Number of records read|
|Update||tblUp||Number of records updated|
|Delete||tblDl||Number of records deleted|
|CSC Age||lastUpd||If enabled, the number of seconds since the user's Client Statement Cache (CSC) was last updated|
|Line#||lineNum||If CSC is enabled, line number of the currently running program|
|Program Name||procName||If CSC is enabled, name of the currently running program|
*Requires data collector "UsersOfTable" in pt3agent.cfg. With the commercial version of ProTop, you can configure alerts using the metric names in this column. For a full list of metrics, see the Alertable Metrics section.