SQLzoo: Find another process and kill it.

Find another process and kill it.

DB2

Sometimes users set off queries that may take a very long time to complete.

We may want to find such long running processes and stop them. Some kind of administrative account is usually required.

Specific to DB2

These commands may be executed by a system administrator using the CLP (command line processor - enter db2 at the prompt). LIST APPLICATIONS.

SQLite
Sometimes users set off queries that may take a very long time to complete. We may want to find such long running processes and stop them. Some kind of administrative account is usually required.
Specific to SQLite
none

MS Access
Sometimes users set off queries that may take a very long time to complete. We may want to find such long running processes and stop them. Some kind of administrative account is usually required.
Specific to MS Access
none

PostgreSQL
Sometimes users set off queries that may take a very long time to complete. We may want to find such long running processes and stop them. Some kind of administrative account is usually required.	SELECT * FROM pg_stat_activity;
Specific to PostgreSQL
none

Oracle
Sometimes users set off queries that may take a very long time to complete. We may want to find such long running processes and stop them. Some kind of administrative account is usually required.	SELECT sid, serial#, username, TO_CHAR(logon_time,'Month dd hh24:mi:ss') FROM sys.v_$session; ALTER SYSTEM KILL SESSION '12,33' -- 12,33 is the sid and serial#
Specific to Oracle

MS SQL Server
Sometimes users set off queries that may take a very long time to complete. We may want to find such long running processes and stop them. Some kind of administrative account is usually required.	USE master; SELECT spid , nt_username, datediff(s,login_time,GETDATE()) FROM sysprocesses; DECLARE @var1 int SELECT @var1 = spid FROM sysprocesses WHERE nt_username='andrew' AND spid<>@@spid EXEC ('kill '+@var1); SELECT spid , nt_username, datediff(s,login_time,GETDATE()) FROM sysprocesses;
Specific to MS SQL Server
sysprocesses in the master database includes all the SQL statements that are currently running. @@spid is your process. @var1 is a local variable.

DB2
Sometimes users set off queries that may take a very long time to complete. We may want to find such long running processes and stop them. Some kind of administrative account is usually required.	LIST APPLICATION; -- 294 and 306 are "Appl Handle" values FORCE APPLICATION (294,306)
Specific to DB2
These commands may be executed by a system administrator using the CLP (command line processor - enter db2 at the prompt). LIST APPLICATIONS.

MySQL
Sometimes users set off queries that may take a very long time to complete. We may want to find such long running processes and stop them. Some kind of administrative account is usually required.	SHOW PROCESSLIST; KILL 16318
Specific to MySQL
Use the KILL command. Does what it says.

Sybase
Sometimes users set off queries that may take a very long time to complete. We may want to find such long running processes and stop them. Some kind of administrative account is usually required.
Specific to Sybase
none

Mimer SQL
Sometimes users set off queries that may take a very long time to complete. We may want to find such long running processes and stop them. Some kind of administrative account is usually required.
Specific to Mimer SQL
We can list the processes with the operating system command miminfo -u We can kill process number 123 in database GISQ with the command mimcontrol -l 123 GISQ

Eine Einführung in SQL