select b.owner,b.object_name,b.object_type
from v$locked_object a,All_Objects b
WHERE a.OBJECT_ID=b.object_id;
select * from v$session where sid in(select sid from v$lock where type='TX');
alter system kill session '301,18225'
from v$locked_object a,All_Objects b
WHERE a.OBJECT_ID=b.object_id;
select * from v$session where sid in(select sid from v$lock where type='TX');
alter system kill session '301,18225'