Sid from Unix Process ID
Here is a situation, This afternoon I have seen my CPU hitting through the roof on a Live system. There are about 6 Oracle instances and one is chewing more than 90% of CPU time.
- I want to know which Instance /process is a culprit
PID USERNAME PRI NICE SIZE RES STATE TIME CPU COMMAND 638523 oracle 52 0 1360M 503M run 574:22 99.10% oracle 958998 oracle 42 0 1363M 506M run 518:12 46.20% oracle 982071 oracle 42 0 1360M 502M WAIT 618:58 38.40% oracle
select s.username, s.status, s.sid, s.serial#, p.spid, s.machine, s.process, s.lockwait from v$session s, v$process p where p.spid = &oracle_pid and s.paddr = p.addr;
Replace ‘&unix_pid’ with 958998
USERNAME STATUS SID SERIAL# SPID MACHINE PROCESS LOCKWAIT SYS ACTIVE 241 38945 958998