Re: Table busy

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
>
Received on Fri Nov 02 2001 - 13:15:52 CST