Execute:
SELECT client_name,session_id, current_timestamp-start_time -
AS ElapTime, commmethod, state, CAST(bytes_sent/1024/1024 AS DEC(8,1)) -
AS "MB_Sent", CAST(bytes_received/1024/1024 AS DEC(8,1)) AS "MB_Rcvd", -
cast((cast(bytes_sent as dec(18,0))/cast((current_timestamp-start_time) -
seconds as decimal(18,0))) / 1024 / 1024 AS DEC (18,1)) AS "Sent_MB/s", -
cast((cast(bytes_received as dec(18,0))/cast((current_timestamp-start_time) -
seconds as decimal(18,0))) / 1024 / 1024 AS DEC (18,1)) AS "Rcvd_MB/s" -
FROM sessions WHERE session_type='Node'
CLIENT_NAME: ATHENA3_SQL2005A
SESSION_ID: 22749
ELAPTIME: 65323.607000
COMMMETHOD: Tcp/Ip
STATE: RecvW
MB_Sent: 0.0
MB_Rcvd: 1195494.6
Sent_MB/s: 0.0
Rcvd_MB/s: 51978.0
CLIENT_NAME: ATHENA3_SQL2005A
SESSION_ID: 22750
ELAPTIME: 65318.607000
COMMMETHOD: Tcp/Ip
STATE: RecvW
MB_Sent: 0.0
MB_Rcvd: 1199778.9
Sent_MB/s: 0.0
Rcvd_MB/s: 66654.3
Read more...



