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 votes202 views1 answer
How to create sql database
SQL
2 votes219 views1 answer
Mysql change data type of column
SQL
16 votes215 views6 answers
Install sqlite3 python
SQL
7 votes207 views2 answers
Show size database mysql
SQL
0 vote210 views1 answer
Mysql c commands
SQL
0 vote196 views1 answer
Difference between 2 query results sql server
SQL
0 vote206 views1 answer
Postgresql delete multiple rows
SQL
3 votes209 views2 answers
Df to sql pandas sql achemy
SQL
0 vote188 views1 answer
Select from 3 tables one is empty
SQL
0 vote212 views1 answer
Sql delete row from table where id
SQL