Re: ORAKILL doesn't work

John wrote:

> 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

SHUTDOWN ABORT
STARTUP
SHUTDOWN IMMEDIATE
STARTUP

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