Error when wanting to update table in oracle 10g: "ORA-00054: resource busy and acquire with NOWAIT specified"


I have a small problem with my database. We connected several users, a moment ago I was working on it, but I was offline. Just when I gave it a commit, when updating a record, then I logged in again, but there was no update to my record. Then I tried to update it but, to my surprise, I got the following error:

ORA-00054: resource busy and acquire with NOWAIT specified

That investigating a bit refers to the fact that the table was blocked, or something like that. I started researching here , here , and other places I visited to find the answer, but so far I could not find it.

Do you know in any way that I do not get that error?
I clarify, it is only on that table and on that specific record.

asked by 5frags 27.04.2017 в 01:28

1 answer


First step1:

select object_name, s.sid, s.serial#, p.spid 
from v$locked_object l, dba_objects o, v$session s, v$process p
where l.object_id = o.object_id and l.session_id = s.sid and s.paddr = p.addr;

Second step:

alter system kill session ''sid,serial#';--sid' y'serial#' Se obtienen en el paso 1.

More info

answered by 27.04.2017 / 01:38