In Oralce, query the lock table records and unlock the tables that are locked in selectb. owner, B. object_name, a. session_id, a. locked_modefromv $ locked.
In Oralce, query the lock table records and unlock the tables that are locked first. select B. owner, B. object_name, a. session_id, a. locked_mode from v $ locked
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.
,