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 vote363 views1 answer
Check current sequence value postgres
SQL
1 vote334 views1 answer
Oracle list constraints
SQL
1 vote361 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote349 views1 answer
Monthly Birthday SQL Query
SQL
2 votes359 views1 answer
Mysql last 7 days including today
SQL
17 votes351 views3 answers
Cast in sql server
SQL
1 vote353 views1 answer
Pl sql insert into table
SQL
0 vote381 views1 answer
Sql script to remove default from column
SQL
1 vote355 views1 answer
Error code 1175 mysql fix
SQL
0 vote351 views2 answers
How to use aggregate functions in sql
SQL