"UserIOActivity" Data Collector
For a detailed discussion of these metrics, see ProTop Real-Time - User IO Activity (u).
To set up an alert on a metric listed here, make note of the Data Collector name at the top of this page, the Alertable Metric and Data Type from the table below and visit Alert Configuration.
| Alertable Metric | ProTop RT Label | Data Type | Description |
| tt_uio | (temptable name) | ||
| dbAccess | BlkAcc | num | Number of database blocks accessed, both reads and writes |
| hitRatio | Hit% | num | Percentage of database reads from database buffer cache |
| lastUpd | CSC Age | char | If enabled, the number of seconds since the user's Client Statement Cache (CSC) was last updated |
| lineNum | Line# | num | If client statement cache is enabled, the line number of the currently executing program |
| lkHWM | LkHWM | num | Lock table concurrent locks high water mark |
| osReads | OSRd | num | Number of operating system reads |
| osWrites | OSWr | num | Number of operating system writes |
| procName | Program Name | char | If client statement cache is enabled, the name of the program that is currently executing |
| recLks | RecLk | num | Number of record locks |
| userFlags | Flags | char | see ProTop Real-Time - User IO Activity (u) |
| userName | Name | char | User login name |
| userNum | Usr# | num | Unique user number |
| userPID | PID | char | Operating System process id |