Script To Generate Alter Statements to Kill Locked Sessions in RDS
Posted by Sriram Sanka on May 28, 2021
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 o
WHERE
s.paddr = p.addr
AND l.sid = s.sid
AND l.id1 = o.object_id
AND s.username = 'XXAPPS' --- Change as needed.
AND object_name like ('XXSC%'); --- Change as needed.
My Experiences with Databases & More 
Leave a Reply