Query for ORAKILL Show Duplicate SPIDs
Hello,
I've run into a situation where a specific process within oracle consumes 100% of the cpu. I've tried the alter session kill 'xx,xxx' immediate and it does not kill the session. So I went looking and found the ORAKILL command with this sql statement to find the spid to put into the command.
I've run into a situation where a specific process within oracle consumes 100% of the cpu. I've tried the alter session kill 'xx,xxx' immediate and it does not kill the session. So I went looking and found the ORAKILL command with this sql statement to find the spid to put into the command.
select spid, s.sid, osuser, s.program, s.username, s.sid, s.serial#
from v$process p, v$session s
where p.addr=s.paddr
and osuser <> 'SYSTEM'
order by spid, s.sid,osuser;
SPID SID OSUSER PROGRAM
------------ ---------- ------------------------------ --------------
10440 880 jvincent sqlplusw.exe
2336 825 patricke sqltalk.exe
0