Database Utilities (MOSC)

MOSC Banner

Query for ORAKILL Show Duplicate SPIDs

edited Jul 3, 2010 5:48AM in Database Utilities (MOSC) 2 commentsAnswered
  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.

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     

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center