who Data Collector

"who" Data Collector

For a detailed discussion of these metrics, see ProTop Real-Time - Who Is Connected (W).

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_who     (temptable name)
connectAge Duration char Length of time connected to the database
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 CSC is enabled, line number of currently executing program
procName Program Name char If CSC is enabled, name of the currently execuring program
statTRX TRX Stat char Transaction Status
usrBlk Blkd char User is waiting for a database-related resource
usrIPAddr Device char Connected device or, if remote client, the IP Address
usrName Name char Name associated with Usr#
usrNum Usr# num Database connection user number
usrServ Server num Number of the server managing the remote client
usrType Flags char User type. Most likely one of the following: SELF service, BROKer, SERVer, REMote & PT3 - ProTop
whoPID PID char Operating system process ID