Tag Archives: AWS

Kill a SQL statement in a session of Oracle AWS RDS

How to cancel a SQL statement running in Oracle AWS RDS Service

Identify the SQL ID , Session ID and Serial# from V$session for cancel

select SID, SERIAL#, SQL_ID, STATUS from V$SESSION where USERNAME = 'USERNAME'

Kill or Cancel a SQL statement in a session of Oracle AWS RDS service:

begin
    rdsadmin.rdsadmin_util.cancel(
        sid    => sid, 
        serial => serial_number,
        sql_id => sql_id);
end;
/