Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Table busy

Table busy

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 2 Nov 2001 17:05:15 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA72DB82F@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 - 11:05:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US