Oracle kill session by sql_id

-- Get Job session IDs
SELECT jr.JOB, s.USERNAME, s.SID, s.SERIAL#, p.SPID, s.LOCKWAIT, s.LOGON_TIME
FROM DBA_JOBS_RUNNING jr, V$SESSION s, V$PROCESS p
WHERE jr.SID = s.SID AND s.PADDR = p.ADDR ORDER BY jr.JOB;
-- Or simply a session
SELECT SID, SERIAL#, STATUS, SERVER FROM V$SESSION WHERE USERNAME = '<username>';
-- Kill session with IDs and wait for rollback if any...
ALTER SYSTEM KILL SESSION 'SID,SERIAL#' IMMEDIATE;
-- To simply stop job without killing session:
BEGIN
    DBMS_SCHEDULER.STOP_JOB(JOB_NAME => 'scheme.job_name', FORCE => TRUE);
END;

Similar codes

2 votes63 views1 answer
Sql group by different columns
SQL
8 votes107 views1 answer
Sql remove leading spaces
SQL
1 vote130 views1 answer
Sql set auto increment back to 0
SQL
1 vote111 views2 answers
Oracle list service names
SQL
0 vote102 views1 answer
Oracle exchange subpartition
SQL
0 vote106 views3 answers
Java hide mysql login credentials
SQL
7 votes119 views2 answers
Where keyword sql
SQL
1 vote102 views2 answers
Difference between in and between in sql
SQL
7 votes100 views1 answer
Sql server convert string to date
SQL
2 votes90 views2 answers
How to get capital letter first in sql
SQL