--- title: 如何 KILL OceanBase 的会话-OceanBase数据库使用指南 description: 了解OceanBase数据库在实际应用中关于 如何 KILL OceanBase 的会话相关的常见问题和使用技巧，帮助您快速解决 如何 KILL OceanBase 的会话的难题。 --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 划线反馈 # 如何 KILL OceanBase 的会话 更新时间：2026-05-14 08:46 适用版本： V2.1.x、V2.2.x、V3.1.x、V3.2.x 内容类型：How-to ## 适用版本 OceanBase 数据库 V2.x 和 V3.x 版本 ## 操作步骤 1. 登录 OceanBase 集群的 SYS 租户，查询所有的 OceanBase 会话信息。 ```shell obclient > select * from oceanbase.__all_virtual_processlist; ``` 返回结果如下： ```shell obclient [(none)]> select * from oceanbase.__all_virtual_processlist; +------------+------+----------+-----------------------+------+---------+------+--------+---------------------------------------------------+-----------------+----------+----------+--------------+---------------+-----------------+-----------+----------------------+-----------+------------+-------------------------------+-------------+ | id | user | tenant | host | db | command | time | state | info | svr_ip | svr_port | sql_port | proxy_sessid | master_sessid | user_client_ip | user_host | trans_id | thread_id | ssl_cipher | trace_id | trans_state | +------------+------+----------+-----------------------+------+---------+------+--------+---------------------------------------------------+-----------------+----------+----------+--------------+---------------+-----------------+-----------+----------------------+-----------+------------+-------------------------------+-------------+ | 3221644091 | root | mysql001 | xxx.xxx.xxx.xxx:21683 | test | Sleep | 6903 | SLEEP | NULL | xxx.xxx.xxx.xxx | 2882 | 2881 | NULL | NULL | xxx.xxx.xxx.xxx | % | 17316708323080480493 | 0 | NULL | NULL | TIMEOUT | | 3221667548 | root | sys | xxx.xxx.xxx.xxx:50546 | NULL | Sleep | 24 | SLEEP | NULL | xxx.xxx.xxx.xxx | 2882 | 2881 | NULL | NULL | xxx.xxx.xxx.xxx | % | 0 | 0 | NULL | NULL | | | 3221655222 | root | sys | xxx.xxx.xxx.xxx:50215 | NULL | Query | 0 | ACTIVE | select * from oceanbase.__all_virtual_processlist | xxx.xxx.xxx.xxx | 2882 | 2881 | NULL | NULL | xxx.xxx.xxx.xxx | % | 0 | 71448 | NULL | YB42AC1E87E5-00060BE57E0D7A12 | | +------------+------+----------+-----------------------+------+---------+------+--------+---------------------------------------------------+-----------------+----------+----------+--------------+---------------+-----------------+-----------+----------------------+-----------+------------+-------------------------------+-------------+ 3 rows in set ``` 2. 找到需要删除的会话信息，并通过其 svr_ip 地址，及 sql_port 端口，登录该主机。 3. 根据查询的会话 ID，删除对应的会话。 ```shell obclient > kill 3221667548; ``` 上一篇 [OBProxy 如何只使用用户名的方式访问某个租户](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000003272013) 下一篇 [OceanBase 数据库网络相关问题的排查方法](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000000707800) ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线