Error message:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Key words: ORA-00054 lock wait
The table cannot be truncated by another process if the table is not committed after the INSERT message is sent.
For example:
Process A creates A new table, inserts A row of data, but does not commit.
ORA-00054: ORA-00054 ORA-00054: ORA-00054: ORA-00054: ORA-00054: ORA-00054: ORA-00054: ORA-00054: ORA-00054: ORA-00054
The truncate of process B can only be executed after process A commits or after the resource is released.
Note that this situation is different from two processes operating on a resource at the same time (e.g., UPDATE on the same row). When two processes are operating on a resource at the same time, the second operation will get stuck (waiting).
You can find the process that holds the resource, commit the resource and release it. If you cannot commit, you can confirm and kill it.
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Key words: ORA-00054 lock wait
The table cannot be truncated by another process if the table is not committed after the INSERT message is sent.
For example:
Process A creates A new table, inserts A row of data, but does not commit.
ORA-00054: ORA-00054 ORA-00054: ORA-00054: ORA-00054: ORA-00054: ORA-00054: ORA-00054: ORA-00054: ORA-00054: ORA-00054
The truncate of process B can only be executed after process A commits or after the resource is released.
Note that this situation is different from two processes operating on a resource at the same time (e.g., UPDATE on the same row). When two processes are operating on a resource at the same time, the second operation will get stuck (waiting).
You can find the process that holds the resource, commit the resource and release it. If you cannot commit, you can confirm and kill it.
SQL> select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;
Note that not all the information that appears after using the above statement is the problem process, because normal operation on the table as long as there is a hold resource in the query will be selected, so you can use this command several times to check whether the resource has been held, and you can look at the table name below to help confirm.
Query for sid and serial#.
SQL> select b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time;
KILL the session process.
Read More:
- Solution to can’t bind to local 8600 for debugger
- Solution to the problem that SQL database query result field contains new line character, which leads to copy to excel dislocation
- Solution to device or resource busy error in docker redeployment service
- (transfer) using Wireshark package capture software to prompt the NPF driver isn’t running solution
- E / Art: failed sending reply to debugger: a solution to broken pipe
- Solution: unable to delete folder (you need permission to perform this operation)
- Solution / error of. Net framework 4.0 installation failure HResult 0xc8000222 solution
- Tns-03505: the ultimate solution to failed to resolve name
- Svn: a solution to the error of cleanup failed to process the following paths
- Solution to “the grub PC ‘package failed to install into / target / when installing Ubuntu server
- Solution to the problem of failure to elect leaders when offline service is reported in Nacos
- A solution to the refusal of rdesktop connection to windows host
- Unrecognized Windows Sockets error: 10106: solution to create
- SSH connection to MAC server shows No route to host solution
- Solution to (ERROR: Failed to build gem native extension.) encountered when updating pod
- Solution to the problem of vs2017 error report unable to open source file
- Upgrade/reinstall win10 system–prompt the solution to fail to verify the key
- Solution to MySQL workbench error 1148 unable to load local data
- [Linux] curl: (7) failed to connect to 127.0.0.1 port 1086: connection reused solution
- Solution to SQL Server Error: 4064