Tuesday, October 4, 2011

Oracle Dynamic Session Kill for sessions in Amazon RDS

For those folks running Oracle Databases in Amazon RDS environment, we can kill sessions using the Amazon API: rdsadmin.rdsadmin_util.kill

select 'exec rdsadmin.rdsadmin_util.kill('|| sid ||',' || serial# || ');'
from v$session where username in ('&myUsername', '&myOtherUserName');

Here is the link to the amazon API doc. awsdocs.s3.amazonaws.com/RDS/latest/rds-ug.pdf

No comments:

Post a Comment