"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
dbAccess Blk Acc 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 Lk HWM num Lock table concurrent locks high water mark
osReads OS Rd num Number of operating system reads
osWrites OS Wr 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 Rec Lck 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