RE: ORA-00054

From: Durinda.Jones <Durinda.Jones_at_yellowcorp.com>
Date: Tue, 1 Aug 2000 11:06:40 -0500
Message-Id: <10576.113494@fatcity.com>

Claudia,

It sounds like a process has a lock on some rows you're trying to delete. That's why you hang when you try the delete. Another process is updating the rows and hasn't issued a commit. This is also why you get the ORA-00054 when you try to delete the table. You need to find out what process has the lock and get them to either commit or rollback. It's possible it might be an orphan process that's never going to complete. In that case you will need to kill the session so it can rollback. Depending on how much that process was doing, rollback could take a while.

You can run the $ORACLE_HOME/rdbms/admin/utllockt.sql to see the blocking locks. Or, use the Lock Manager in OEM (my preferred way, but not everybody has that option).

Durinda Jones
Yellow Technologies

-----Original Message-----
From: Rivera, Claudia [mailto:crivera_at_utep.edu] Sent: Tuesday, August 01, 2000 10:05 AM
To: Multiple recipients of list ORACLE-L Subject: ORA-00054

I need to erase some rows from a table. But when I try to do it, nothing happens.
The system just hangs in there until I press Ctrl C to stop it.

Now, I tried to drop the table, and it gave me the following error:

ORA -00054 Resource busy and acquire with NOWAIT specified.

What does this mean??

This is the only table with this type of problem.

Everything else works fine.

TIA

--------------Claudia Rivera-----------------

The University of Texas at El Paso
Tech. Media Coordinator
crivera_at_utep.edu
http://dmc.utep.edu

-- 
Author: Rivera, Claudia
  INET: crivera_at_utep.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Aug 01 2000 - 11:06:40 CDT