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

5 votes307 views1 answer
Postgres upsert
SQL
0 vote358 views1 answer
Mysql subtract month from timestamp
SQL
0 vote361 views1 answer
Mariadb search columns
SQL
0 vote433 views1 answer
Plpgsql create function
SQL
2 votes370 views2 answers
Convert_tz mysql
SQL
0 vote346 views2 answers
Sql join on comma separated field
SQL
1 vote372 views1 answer
Sql server insert into temp table
SQL
0 vote372 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
2 votes318 views1 answer
Mysql auto increment jumping
SQL
1 vote366 views1 answer
Insert value to new table by joining 2 different tables
SQL