说明
如果您拥有 PROCESS 权限,则您可以查看所有会话。如果您拥有 SUPER 权限,您可以终止所有会话和语句。否则,您只能查看和终止您自己的会话和语句。
+------------+-------+--------------------+------+---------+------+--------+------------------+
+------------+-------+--------------------+------+---------+------+--------+------------------+
| 3221638213 | admin | 1.11.111.127:11161 | test | Query | 0 | ACTIVE | select "abcedfg" |
+------------+-------+--------------------+------+---------+------+--------+------------------+
1 row in set (0.03 sec)
OceanBase(admin@test)>kill query 3221638213;
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)