Re: how can I kill a session who's status is "KILLED"?

Check the Oracle session background process to see if it is getting time; if it is getting time then Oracle is probably using it to rollback the terminated transaction. The session locks will go away when the rollback is complete. If you kill the Oracle session background process then pmon will take over the rollback, but the desired rows will still be unavailable to another session until the backout is complete.

If the session background process is getting no time then kill it at the OS level so pmon takes over.

There have been a couple of bugs in past versions where under certain situations the v$session entry was not removed and you have to bounce the instance to clear the entry and free the held resources.

ceiling <ceiling_at_autumn.ccl.itri.org.tw> wrote in article <7he325$527$1_at_news.itri.org.tw>...
> HI ALL:
> In Oracle 8.0.3 Server,there are a session who's status is "KILLED",
> I Need to kill this session because it lock a table,
> but when I try to kill this session,
> "ALTER SYSTEM KILL SESSION 'sid,serial#';
> and get the following error message:
> ORA0---31:session marked for kill,
> and this session still reside in the databse,
> Can anyone tell me how to kill this "KILLED" session.
> Thank You in advance.
>
>
>
>
Received on Thu May 13 1999 - 07:59:47 CDT