Oracle lock table Query and Unlock

If the data in the Oracle data table is not responding when it is being hacked, it is likely that the table is locked. Use the following command to resolve the locking problem.

Lock table Status query. Copy and paste directly to it.

--Lock Table Query Sqlselect object_name, machine, S.sid, s.serial# from Gv$locked_object L, dba_objects o, gv$session s WHERE l.object _id = o.object_id and l.session_id = S.sid;

Unlock and need to fill in the SID and SERIAL that were investigated in the previous step

--Release session SQL:--alter system kill session ' Sid, Serial# '; ALTER system kill session ' 235, 49711 ';

Oracle lock table Query and Unlock