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 vote127 views1 answer
How to alter length character varying postgres
SQL
0 vote109 views1 answer
Install mysql 8 linux
SQL
10 votes126 views2 answers
Forgot my mysql password mac
SQL
1 vote123 views1 answer
Sql oracle update multiple rows
SQL
0 vote73 views1 answer
Postgres delete where id in
SQL
0 vote115 views1 answer
Oracle exchange subpartition
SQL
4 votes111 views1 answer
Mysql insert from local csv
SQL
3 votes134 views3 answers
Restart mysql mac
SQL
0 vote110 views6 answers
Unique key in sql
SQL
5 votes150 views2 answers
Add days in oracle sql
SQL