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%';
