Cancel the Sessions Holding Locks on Application Objects

1. Run the following query:

   SELECT 'alter system kill session'||''''||sid||','||serial#||''''||' immediate;'from v$session where sid in ( select session_id FROM sys.dba_ddl_locks 
   WHERE (name like 'CDR_%' or name like 'DME_%') );

2. Run the alter statement to cancel the active sessions.