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

1 vote278 views4 answers
Mysqldump 1 table only
SQL
3 votes276 views3 answers
Update join
SQL
0 vote306 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote250 views8 answers
Convert sql query to linq online
SQL
1 vote248 views1 answer
Stored procedure return value
SQL
0 vote297 views1 answer
Postgresql create table many-to-many
SQL
-1 vote289 views1 answer
How to dump .csv file into mysql
SQL
1 vote280 views2 answers
How to enable error squiggles in vs code
SQL
0 vote267 views1 answer
Renommer schema sql
SQL
0 vote319 views1 answer
Mysql relationships between tables
SQL