Oracle processes running wild

From: Dennis Bieling <dennis.bieling_at_epigenomics.com>
Date: Tue, 24 Feb 2004 09:41:23 +0100
Message-ID: <c1f2nk$vt6$1@broglie.epigenomics.epi>

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 Received on Tue Feb 24 2004 - 02:41:23 CST