UserIOActivity Data Collector

"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