How to Kill the Session For the Database Objects:

select * from dba_ddl_locks where name='XX_LISTENER_PK1';

select * from v$session where sid=722;

alter system kill session '722,49407' immediate;

 

Regards,

Avinash Kumar