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

3 votes206 views1 answer
Where id is in list sql
SQL
0 vote199 views3 answers
Sql drop all tables
SQL
0 vote192 views1 answer
Psql check if sql script is valid
SQL
1 vote287 views1 answer
Sql server delete top 1000
SQL
0 vote248 views1 answer
Oracle plsql sleep
SQL
1 vote213 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote187 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote181 views3 answers
Joins and views sql
SQL
1 vote196 views1 answer
Sqlserver create table from select
SQL
0 vote169 views1 answer
Full syntax inner join
SQL