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

0 vote194 views1 answer
Mysql update even / odd rows
SQL
2 votes202 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote189 views1 answer
Mysql workbench primary key
SQL
0 vote206 views1 answer
Sqlite trim
SQL
0 vote193 views1 answer
Oracle search in date columns
SQL
2 votes142 views1 answer
Oracle current date without time
SQL
0 vote195 views1 answer
Compare two tables to find unmatched records
SQL
0 vote193 views1 answer
Pl sql constraint user function
SQL
8 votes185 views2 answers
Mysql query dates between two dates
SQL
4 votes199 views2 answers
Oracle unlock user
SQL