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 vote129 views1 answer
Metada in sql
SQL
10 votes150 views2 answers
Forgot my mysql password mac
SQL
34 votes135 views5 answers
Oracle alter table add column
SQL
1 vote138 views1 answer
Best sql course
SQL
2 votes145 views1 answer
Oracle index size
SQL
4 votes140 views4 answers
Start mysql
SQL
14 votes147 views2 answers
Oracle export trigger ddl
SQL
3 votes134 views1 answer
How to remove characters from string in mysql
SQL
1 vote138 views1 answer
Where date = max(date) in sql
SQL
16 votes165 views5 answers
Select last row in sql
SQL