セッションkill

• Oracle

select * from v$session;
select SID,SERIAL#,schemaname,status from v$session;

alter system kill session '44,20184';

• MySQL

show processlist;
show full processlist;

select * from performance_schema.threads;

kill 16;

• PostgreSQL

select * from pg_stat_activity;

pidを指定する

select pg_cancel_backend(24634);
select pg_terminate_backend(24634);

 

• SQL Server

select * from sys.dm_exec_sessions where host_name is not NULL;
go

KILL 58;
GO