Search Oracle-locked tables and unlock tables

Search Oracle-locked tables and unlock SQL code: selectobject_name, machine, s. sid, s. serial # fromv $ locked_objectl, dba_objectso, v $ sessi

Search Oracle-locked tables and unlock SQL code: select object_name, machine, s. sid, s. serial # from v $ locked_object l, dba_objects o, v $ sessi

Search Oracle-locked tables and unlock tables

SQL code:

Select object_name, machine, s. sid, s. serial #
From v $ locked_object l, dba_objects o, v $ session s
Where l. object_id = o. object_id and l. session_id = s. sid;

Use this statement to retrieve the locked information.

Run again

SQL code:

Alter system kill session '[SID], [SERIAL]';

,