====== Session commands ======

===== Show all processes =====

  show processlist

Alternatively a query can be used:

  select id,user, host, db, command, time, state, info, progress
  from information_schema.processlist

===== Kill a process =====

  kill 100

100 is the process id listed above.

===== Oracle compatibility =====

To run queries with Oracle syntax, you can use:
<code sql>
SET SESSION sql_mode='ORACLE'
</code>

<note>This is available only in MariaDB 10.3 and higher</note>