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

10 votes269 views1 answer
How to import database in mysql by cmd
SQL
0 vote291 views1 answer
Postgres statistics
SQL
1 vote316 views1 answer
Oracle transaction rollback not working
SQL
0 vote320 views1 answer
Sql cursor example multiple columns
SQL
0 vote280 views1 answer
Snap craft
SQL
27 votes293 views6 answers
Sql update record
SQL
0 vote296 views1 answer
Sql tablo sp
SQL
0 vote271 views1 answer
How to check if there is no database schema
SQL
13 votes297 views1 answer
Select count of distinct values sql
SQL
15 votes287 views4 answers
Sql update from select
SQL