<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: Find SID session oracle from PID process OS

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

0 Commenti:

Posta un commento

Iscriviti a Commenti sul post [Atom]



<< Home page