Query to find and remove Oracle database locks

Query to find and remove Oracle database locks
Oracle database locks
oracle lock table
blocking session in oracle
oracle deadlock
oracle lock
oracle locked objects
query to check locks in oracle database
oracle table lock query
oracle show locks
find blocking session in oracle
oracle db lock
oracle check locks
query to find locked objects in oracle
oracle check table lock
How to find the Oracle database locks
How to remove locks from Oracle database

1-- Use below query to find locked objects
2select
3c.owner,
4c.object_name,
5c.object_type,
6b.sid,
7b.serial#,
8b.status,
9b.osuser,
10b.machine
11from
12v$locked_object a ,
13v$session b,
14dba_objects c
15where
16b.sid = a.session_id
17and
18a.object_id = c.object_id;
19
20
21--use below query to kill the blocking session
22
23ALTER SYSTEM KILL SESSION '1398,21328' --SID and SERIAL# from above query
24
25--