Show session speed real time TSM

I find with google search this query :

select char(client_name,10) as “Sess”,CAST(CAST(bytes_received/1024/1024 as decimal(15,0))/CAST((current_timestamp-start_time)seconds as decimal(15,0)) as decimal(10,2)) as “Receive [MB/s]”,CAST(CAST(bytes_sent/1024/1024 as decimal(15,0))/CAST((current_timestamp-start_time)seconds as decimal(15,0)) as decimal(10,2)) as “Sent [MB/s]” from sessions where session_type=’Node’

output:

Sess             Receive [MB/s]       Sent [MB/s]
———–     —————     ————-
KELLY                   4193.64              0.00
KELLY                      0.00              0.00

Show session speed real time TSM

Leave a Reply

Your email address will not be published.