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 vote216 views1 answer
Sql delete dastabase
SQL
1 vote303 views4 answers
Alter schema sql
SQL
2 votes232 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote309 views1 answer
Oracle sql all days except weekends
SQL
0 vote222 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote316 views1 answer
How to get table current identity value in sql server
SQL
0 vote255 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote197 views1 answer
Default order by in mysql
SQL
0 vote221 views1 answer
Oracle chain step succeeded
SQL
1 vote184 views1 answer
Mysql check string don't have number
SQL