Thursday, November 3, 2016

Who is consuming more CPU(IN  LINUX) in oracle 


select sid, serial#, program,module, osuser,machine from v$session where paddr= (select addr from v$process where spid=4357)

here 4357 is the process id which can be found by using TOP command,select the high CPU consuming process.

No comments:

Post a Comment