-
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.
-
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.
-
solution
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
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|