Script to generate Kill Locked Sessions in Oracle : In case of RDS , SELECT ‘exec rdsadmin.rdsadmin_util.kill(‘||s.sid ||’,’|| s.serial# ||’ );’FROM v$session s ,v$process p ,v$lock l ,dba_objects oWHEREs.paddr = p.addrAND l.sid = s.sidAND l.id1 = o.object_idAND s.username = ‘XXAPPS’ — Change as needed.AND object_name like (‘XXSC%’); — Change as needed.