Cancel the Sessions Holding Locks on
Application Objects
Cancel the Sessions Holding Locks on
Application Objects
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_%') );
Run the alter statement to cancel the active sessions.