Kill Session for SQL_ID in Oracle

Kill the Session which running SQLID
Put the SQL ID for kill the session

SELECT 'alter system kill session '''|| SID || ',' || SERIAL# || ''' immediate ;'
FROM v$session
WHERE sql_id = '&sql_id';

-- In RAC
SELECT 'alter system kill session '''|| SID|| ','|| SERIAL#|| ',@'|| inst_id|| ''' immediate ;'
FROM gv$session
WHERE sql_id = '&sql_id'

Check the SQL ID from SQL TEXT

SELECT sql_id FROM v$sql WHERE sql_text LIKE 'SELECT * FROM HR.EMP%';