How to kill the session in Oracle database of Amazon RDS service AWS
Identify the session with the following query:
SELECT SID, SERIAL#, STATUS FROM V$SESSION WHERE USERNAME = 'USERNAME';
Kill the session by using AWS rdsadmin package provided by AWS
BEGIN
rdsadmin.rdsadmin_util.kill(
sid => sid,
serial => serial_number,
method => 'IMMEDIATE');
END;
/