Re: Forcing Oracle to release locked objects

I thank you for your answer but the problem is a bit more complex...

The fact is that the session is already marked for killing (and in fact its status is 'KILLED'), but objects are still locked. Maybe Oracle tries to gently finish the transaction before releasing locked objects? If so, it won't never succeed in this because the session does not exist anymore...
After three (!) days the session status was still 'KILLED' and objects still locked.

I still can't explain it to me...

--
Fulvio Catto
@logistics Reply s.r.l.
Via Ripamonti, 89
20139 Milano
f.catto_at_reply.it
www.reply.it

"Ganesh Raja" <ganesh_at_gtfs-gulf.com> wrote in message
news:k5qr6ukgrc7o6gdoteoqvbb959ul1ta9k1_at_4ax.com...


> IMP Is not locking your objects... It is the server process that is

spawned to


> do this work for you.

>

> With time this will get resolved by PMON... But if u need to rel those

locks


> then use the v$locked_object and v$sesion to find the stray process and

kit it.


>

> HTH

>

> On Fri, 15 Feb 2002 10:54:22 GMT, "Fulvio Catto" <f.catto_at_reply.it> wrote:

>

> >

> >I was performing an import on Oracle8i (rel. 2) DB using IMP.EXE. Before

the


> >import finished, it crashed leaving some objects in the DB locked.

> >It was not possible to unlock them unless shutting down and restarting

the


> >DB.

> >

> >Does anyone know other means to unlock objects locked by a process (such

as


> >IMP) ?

> >

> >Thanks in advance

>

> [Additions and Corrections Always Welcome.]

> Best Regards,

> Ganesh R