oracle kill session by sql id

Solutions on MaxInterview for oracle kill session by sql id by the best coders in the world

showing results for - "oracle kill session by sql id"
Wallace
05 Mar 2018
1-- Get Job session IDs
2SELECT jr.JOB, s.USERNAME, s.SID, s.SERIAL#, p.SPID, s.LOCKWAIT, s.LOGON_TIME
3FROM DBA_JOBS_RUNNING jr, V$SESSION s, V$PROCESS p
4WHERE jr.SID = s.SID AND s.PADDR = p.ADDR ORDER BY jr.JOB;
5-- Or simply a session
6SELECT SID, SERIAL#, STATUS, SERVER FROM V$SESSION WHERE USERNAME = '<username>';
7-- Kill session with IDs and wait for rollback if any...
8ALTER SYSTEM KILL SESSION 'SID,SERIAL#' IMMEDIATE;
9-- To simply stop job without killing session:
10BEGIN
11    DBMS_SCHEDULER.STOP_JOB(JOB_NAME => 'scheme.job_name', FORCE => TRUE);
12END;