Re: Oracle processes running wild

Dennis Bieling wrote:

> Hi!
>
> I have the following problem. On one of our database instances (9ir2)
> there are 3 oracle processes running wild for 2 days now, using each
> 100% CPU performance, so there is only one more left for real business .
> I identified the 3 sessions
> that are responsible for these prozesses. After asking the user
> who is the owner of these sessions, he told me that he doesn't know
> about the sessions and that probably a statement was aborted.
> When I looked at the SQL that belongs to the sessions, there was no
> statement associated with any of these sessions. Therefore I decided
> to kill those sessions. They are now marked as "killed", but the
> operating system processes are still active and using still
> 3 of the 4 CPUs. What can I do to get rid of them without stopping the
> database? Is it save to kill these oracle processes?
>
> Best regards
> Dennis

I know others have advised differently ... but I have never hesitated to apply a small thermonuclear device, kill -9, and never once had a problem.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)