Oracle Find Locked Objects (SQL)

Finding Locked in Oracle can be tricky. I use the below approach.

--Locked Objects (Get SID from this query)
select o.object_name,lo.* from v$locked_object lo , dba_objects o
where lo.object_id = o.object_id
and o.object_name like '%' ;
--and o.object_type = 'PACKAGE'

This query finds all the locked objects. You can filter on packages. Sometimes the object may not appear in the above list. Then the below query might help.

--get serial and sid from this query
select * from v$session where sid = 215 or module like 'XX%';

--sid,#serial
alter system kill session '316,25481';