Tag Archives: AWS

Kill the session in Oracle Amazon RDS AWS

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;
    /