ORAKILL doesn't work

From: John <john.lehew_at_hp.com>
Date: 30 Apr 2003 09:01:43 -0700
Message-ID: <938581bd.0304300801.24b2cf97@posting.google.com>

After noticing a SELECT statement that hung on Oracle 8i and Win2K, an ALTER SYSTEM KILL SESSION command was issued to kill the session.

After four hours, we tried to TRUNCATE the same table the original SELECT statement/session was using; however, it apparently was still holding onto the table we were trying to TRUNCATE.

Next we tried ORAKILL. It's been 3 hours since then and the database is not under much of a load ( 5% CPU ) and the original session is still in its 'KILLED' state.

Is there anything else that can be done?

Thank you,
John Received on Wed Apr 30 2003 - 11:01:43 CDT