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.