<data:blog.pageTitle/>

This Page

has moved to a new address:

https://vmvirtual.blog

Sorry for the inconvenience…

Redirection provided by Blogger to WordPress Migration Service
BIOLNX: Show session speed real time TSM

venerdì 23 agosto 2013

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



Etichette: , , , , , ,

0 Commenti:

Posta un commento

Iscriviti a Commenti sul post [Atom]



<< Home page