Re: Resolve TM lock

From: <jdarrah_co_at_my-deja.com>
Date: Wed, 22 Nov 2000 15:26:55 GMT
Message-ID: <8vgojk$p55$1@nnrp1.deja.com>

If you kill a session, PMON still needs to come in and perform a rollback of any non committed transactions for that session. This can take a while.

In article <uFHS5.8$MI4.160808_at_news.interact.net.au>, "Chuan Zhang" <chuan_at_asiaonline.net> wrote:
> Hi, all
>
> I got an error when I drop a table "ORA-00054: resource busy and
acquire
> with NOWAIT specified".
>
> I figure out that table was locked by a session. Therefore, I
use "alter
> system kill session 'sid,serial#' " to kill session. Finally, that
session
> is marked "killed".
>
> Again, I still cannot drop that table.
>
> Have any idea what anything I can do for this situation.
>
> My platform is on Solaris 2.7, Oracle EE 8.1.5.
>
> Many Thanks
>
> Chuan
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 22 2000 - 09:26:55 CST