Query and unlock lock table records in Oralce

Query and unlock lock table records in Oralce

First, query the tables that are locked.
 
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;

Query the sid and serial of the locked table # Then kill
 
Select B. username, B. sid, B. serial #, logon_time
From v $ locked_object a, v $ session B
Where a. session_id = B. sid and sid in (
Select a. SESSION_ID
From v $ locked_object a, dba_objects B
Where B. object_id = a. object_id) order by B. logon_time

Unlock
 
Alter system kill session '2010 3' immediate; (589,269 is sid, 589 is serial)

In addition, you must have the database management permission to perform this operation. Otherwise, the database cannot be unlocked.