Ora-00054:resource busy and acquire with NOWAIT specified or timeout expired in Oracle

The following error occurs when inserting, updating, deleting data from a table, or adding a table's primary key or index to a database user:

Ora-00054:resource busy and acquire with NOWAIT specified or timeout expired

This is because a transaction is in progress or the transaction has been locked, resulting in an unsuccessful

1) with DBA Authority user queries What locks are in the database

Select T2.username,t2.sid,t2.serial#,t2.logon_time from V$locked_object t1,v$session T2 where T1.session_id=t2.sid Order BY T2.logon_time;

depending on the query results, you can see the user Ad,sid to 5185,serial# for 11357

2) According to SID queries specific SQL statements, and if SQL is not important, you can kill them directly .

Select Sql_text from v$session a,v$sqltext_with_newlines b where DECODE (A.sql_hash_value, 0, Prev_hash_value, sql_hash_ Value) =b.hash_value and a.sid=&sid order by piece;

3) Kill the transaction

Alter system kill session ' 5185,11357;

4) Then perform the actions you need to perform

Ora-00054:resource busy and acquire with NOWAIT specified or timeout expired in Oracle