Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Table busy
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 - 11:05:15 CST