Re: Table busy

Raymond wrote:
>
> Often, you have to kill the dedicated server process on the host machine as
> well.
>
> "Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
> news:E2F6A70FE45242488C865C3BC1245DA72DB82F_at_lnewton.leeds.lfs.co.uk...
> > When a session is 'knocked off' or killed, it doesn't vanish straight
> > away. PMON comes awake at certain times and checks for lost processes
> > and if found, rollsback all uncommited transactions and releases locks
> > for the lost process. I have found that a 20 minute wait from the time a
> > process is killed to the time the PMON does its stuff is not unusual.
> >
> > HTH
> >
> > Regards,
> > Norman.
> >
> > ------------------------------------------------------------------------
> > -----
> > Norman Dunbar EMail: Norman.Dunbar_at_LFS.co.uk
> > Database/Unix administrator Phone: 0113 289 6265
> > Fax: 0113 289 3146
> > Lynx Financial Systems Ltd. URL: http://www.Lynx-FS.com
> > ------------------------------------------------------------------------
> > -----
> >
> >
> > -----Original Message-----
> > From: pvenkatesan_at_hotmail.com (Venkatesan P)
> > [mailto:pvenkatesan_at_hotmail.com]
> > Posted At: Friday, November 02, 2001 4:14 PM
> > Posted To: server
> > Conversation: Table busy
> > Subject: Table busy
> >
> >
> > Hi,
> >
> > I use oracle 8.1.6 on AIX. I ran an insert in SQLPlus like this.
> >
> > >>truncate table CK.DB0005;
> > >>insert into CK.DB0005 select ............. from CK.TB0005 ;
> >
> > I was running this in background.
> >
> > Since this took long time to process because of volume, i killed the
> > SQLplus process.
> >
> > when i tried to run the same thing in batch again, I got the following
> > error msg.
> >
> > truncate table CK.DB0005
> > *
> > ERROR at line 1:
> > ORA-00054: resource busy and acquire with NOWAIT specified
> >
> >
> > When i called my DBA he found the first query, still running and
> > knocked off that session for me.
> >
> > Even after that, i get the same error msg while Truncating.
> >
> > I end up requesting for bouncing the database instance, whenever this
> > happens.
> >
> > Any help on this issue would be highly appreciated.
> >
> > Thanks
> > Venkat
> >

Even killing it off will still need to wait for PMON to rollback any changes...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."