User IO Activity (u)

User IO Activity (u)


Display IO activity by user.

ProTop RT Label Alertable Metric* Description
Usr# usrNum Unique user number
Name usrName User login name
PID userPID Operating System process id
Flags userFlags See table below
Blk Ac dbAccess Number of database blocks accessed, both reads and writes
OS Rd OSReads Number of operating system reads
OS Wr OSWrites Number of operating system writes
Hit % hitRatio Percentage of database reads from database buffer cache
Rec Lck recLks Number of record locks
Lck HWM lkHWM Lock table concurrent locks high water mark
CSC Age lastUpd If enabled, the number of seconds since the user's Client Statement Cache (CSC) was last updated
Line# lineNum If client statement cache is enabled, the line number of the currently executing program
Program Name procName If client statement cache is enabled, the name of the program that is currently executing

*Requires data collector "UserIOActivity" 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.

Flag values

Flag Description
S Shared memory client
R Remote client
L Login broker
@ Server
H helper
O Other
4 4GL Client
W Webspeed client
B Batch client
A Application server
X Unknown
* Transaction active
d Disconnecting
r Undo or error
I STOP or Ctrl-c
N- Notification pending
-N Notification in process
NN Notification pending and in process