Search and unlock locked tables in oracle

-- Check all the locked table selectb. ownerTABLEOWNER, B. object_nameTABLENAME, c. OSUSERLOCKBY, c. USERNAMELOGINID, c. sidSID, c. SERIAL # SERIALfromv $ locked_objecta, dba_objectsb, v $ sessioncwhereb. object_ida.object_idANDa.SESSION_IDc

-- Find all the locked tables, select B. owner TABLEOWNER, B. object_name TABLENAME, c. osuser lockby, c. username loginid, c. sid SID, c. SERIAL # SERIAL from v $ locked_object a, dba_objects B, v $ session c where B. object_id =. object_id AND. SESSION_ID = c

-- Find all locked tables
Select B. owner TABLEOWNER, B. object_name TABLENAME, c. OSUSER LOCKBY, c. USERNAME LOGINID, c. sid, c. SERIAL # SERIAL
From v $ locked_object a, dba_objects B, v $ session c
Where B. object_id = a. object_id AND a. SESSION_ID = c. sid;

-- Unlock through SID and SERIAL
Alter system kill session 'sid, SERIAL ';

Lock table

Lock table BSZ1_W_DOT010_PB01T252_wk2 in exclusive mode;

Conn sys/orcl AS SYSDBA

Alter user hr identified by hr account unlock;

Alter user scott account unlock;