SID status INACTIVE but PID consuming 100% cpu..
Hi Experts,
I am observing some of the processes consuming 90-100% through Top command. so i checked the particular Sid for the PID by
select sid, b.serial#, osuser, b.username, status, process, paddr, spid,a.program, module from
v$process a,v$session b where spid = '&spid' and a.addr = b.paddr and b.username != ' ' order by 1
But many Sid's which i find for the PID which are consuming more % are in INACTIVE status.
My question is why the status of them is showing INACTIVE even though PID of that session is showing 90 - 100% cpu usage.
I am observing some of the processes consuming 90-100% through Top command. so i checked the particular Sid for the PID by
select sid, b.serial#, osuser, b.username, status, process, paddr, spid,a.program, module from
v$process a,v$session b where spid = '&spid' and a.addr = b.paddr and b.username != ' ' order by 1
But many Sid's which i find for the PID which are consuming more % are in INACTIVE status.
My question is why the status of them is showing INACTIVE even though PID of that session is showing 90 - 100% cpu usage.
0