Oracle prompts "the resource is busy and nowait needs to be specified" SOLUTION

InOracleDuring database operations, the following message is displayed during table operation: "The resource is busy. You needSpecify nowait"How can we solve this problem? This article introduces this solution, hoping to help you.

The solution is as follows:

1. Use this statement to query the SESSION_ID being locked:

 
 

  
  
SELECT  SESSION_ID   FROM   V$LOCKED_OBJECT,USER_OBJECTS    
  
  
 
  
  
WHERE   V$LOCKED_OBJECT.OBJECT_ID   =   USER_OBJECTS.OBJECT_ID 
 
 

2. query SERIAL by SESSION_ID found in step 1 #:

 
 

  
  
SELECT SERIAL# FROM V$SESSION  WHERE SID='143' 
 
 

3. Run SESSION_ID and SERIAL # In Step 1:

 
 

  
  
Alter system kill session '2010 6' (48 is the value of SESSION_ID and 48,247 is the value of SERIAL)
  
  
 
  
  
Alter system kill session '2017, 60'
 
 

The above is the prompt "resource busy, need to specify nowait" to unlock the Oracle operation table. I hope this introduction will bring you some benefits. Thank you!