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