Category Archives: Cloud

Blogs about the information of Cloud technologies

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