Re: ORAKILL doesn't work

From: Scott Watson <nospam_abuse_at_hotmail.com>
Date: Wed, 30 Apr 2003 15:40:55 -0400
Message-ID: <9FVra.739$nn.23454@wagner.videotron.net>

Are you sure there is no rollback occuring?

Scott.

"John" <john.lehew_at_hp.com> wrote in message news:938581bd.0304300801.24b2cf97_at_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 - 14:40:55 CDT