<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

BIOLNX

giovedì 8 ottobre 2015

Find SID session oracle from PID process OS

From TOP command linux i have found a proccess oracle this use many CPU. The PID proccess 6434

From Oracle connession i haved launched this select:

SQL> select sid from v$session, v$process
  2   where paddr = addr
  3    and spid = '6434';




This is output of select

       SID
----------
       338



Etichette: , , , , ,

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: , , , , , ,