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 vote164 views1 answer
Composit key in sql
SQL
0 vote189 views2 answers
Select last 30 days sql
SQL
0 vote170 views1 answer
Postgresql where clause not working
SQL
8 votes196 views1 answer
Oracle search text in all packages
SQL
0 vote179 views1 answer
Connecting to my cloud sql server with c#
SQL
22 votes161 views6 answers
Create sql table
SQL
0 vote172 views1 answer
Copy row from db to db mysql
SQL
0 vote175 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote169 views1 answer
Mysql repair a table
SQL
1 vote125 views1 answer
File /etc/init.d/mysql not exists
SQL