Re: Forcing Oracle to release locked objects

These 'objects'. Are they snapshots by any chance?

Paul

"Fulvio Catto" <f.catto_at_reply.it> wrote in message news:LvRb8.11275$8F6.536385_at_twister2.libero.it...
> 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
>
>
Received on Sun Feb 17 2002 - 13:08:51 CST