Re: table locked

On Sat, 9 Mar 2002 11:07:34 +0100, "Titi" <thierry.constant2_at_wanadoo.fr> wrote:

>Hi,
>
>I have the following problem:
>
>because the application dead, a table is locked,
>I do a "alter system kill session '22,33'"
> the status of the lock changed to "killed", but the lock still exists.
>The only solution I found is to shutdown abort /startup
>
>Is there a better solution for this problem ???
>
>Thanks for your answer ...
>
>
>

select s.sid, s.serial#, p.spid
from v$session s, v$process p
where p.addr = s.paddr
and <any extra parameters>

now issue a
host kill -9 <spid> -- Unix
or
host orakill <spid> -- NT

and in a few secs........presto.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Mar 09 2002 - 05:18:33 CST