Oracle11g error ORA-00054: the resource is busy, require the specified NOWAIT how to solve ?, Oracle11gnowait

Oracle11g error ORA-00054: the resource is busy, require the specified NOWAIT how to solve ?, Oracle11gnowait

Oracle11g a table can only query, add, delete, modify are not allowed, can not drop, and truncate all fail will report the error ORA-00054: the resource is busy, require the specified NOWAIT

The procedure is as follows:

View the locked table and the session that causes the lock:

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

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

Select xidusn, object_id, session_id, oracle_username, OS _user_name from v $ locked_object;

Select object_id, object_name from dba_objects where object_id = '2013'

Alter system kill session '25, 1 ';

Select a. spid, B. sid, B. serial #, B. username, B. status from v $ process a, v $ session B where a. addr = B. paddr

In windows cmd.exe cute line orakill oracle_instance spid

After the process is killed, it can truncate and solve the problem.