MDA_NETWORK_IO

Network I/O activity by processes

ROWID

(SPID, KPID)

Columns

Name Data Type Description
INSTANCEID long Instance ID; 0 = non-CE
SPID long Session process ID
KPID long Kernel process ID
NETWORKPACKETSIZE long Network packet size
PACKETSSENT long Number of network packets sent
PACKETSRECEIVED long Number of network packets received
BYTESSENT long Network bytes sent
BYTESRECEIVED long Network bytes received
NETWORKENGINENUMBER long Network engine ID for the process
TSYNC long Internal-use tsync; created by Surveillance
Note: This column may be removed in a future release.
LOGIN string(32) Login name
APPLICATION string(32) Application name
COMMAND string(32) General command type
TEMPDBNAME string(32) TempDB name
MERGESTATUS long Internal-use merge status; created by Surveillance
PACKETSSENT_DELTA double Delta number of network packets sent
PACKETSSENT_RATE double Number of network packets sent per second, in interval
PACKETSSENT_RATE_AVG double Average number of network packets sent per second, since collection started
PACKETSRECEIVED_DELTA double Delta number of network packets received
PACKETSRECEIVED_RATE double Number of network packets received per second, in interval
PACKETSRECEIVED_RATE_AVG double Average number of network packets received per second, since collection started
BYTESSENT_DELTA double Network bytes sent delta
BYTESSENT_RATE double Network bytes sent per second, in interval
BYTESSENT_RATE_AVG double Average network bytes sent per second, since collection started
BYTESRECEIVED_DELTA double Network bytes received delta
BYTESRECEIVED_RATE double Network bytes received per second, in interval
BYTESRECEIVED_RATE_AVG double Average network bytes received per second, since collection started
BYTESTRANSFERRED_RATE_AVG double Total network bytes sent and received per second, in interval
PACKETSTRANSFERRED_RATE_AVG double Total number of network packets sent and received per second, in interval

Requirements

Attributes: MDA
Minimum database version: 12.5.0.3