ora-00054 Error!Resource busy!

[amitstora]

Hi all!

Query:

1.I encountered this error to-day:

ora-00054:resource busy and acquire with noawait result.

Why this error occurs!

What should be done to solve this!

Regards,

Amitstora.

[julian]

Nothing. Retry. This is a quite normal message and is reported if a SQL statement would have blocked waiting for
another user to complete some operation.

[padmam]

Dear Friend, 2nd Sep 2001 17:11 hrs chennai

Problemra-00054:resource busy and acquire with noawait result.

Cause:While you're trying to alter/drop a table when someone is busy updating the thing.

Solution:Run the fololwing script to find the root cause user and kill his session.

-----------------------------------
column oracle_username heading "Ora User" format a10
column os_user_name heading "OS User" format a10
column session_id heading "Sess#" format 999
column process heading "PID" format 999999
column object_name heading "Object" format a30

select oracle_username,
os_user_name,
session_id,
process,
object_name
from v$locked_object a,
dba_objects b
where a.object_id = b.object_id
order by oracle_username
/

clear columns
--------------------------------

Cheers

Padmam