---
title: "常见等待事件说明 - OceanBase 数据库 V4.2.5 | OceanBase 文档中心"
description: 常见等待事件说明 等待事件介绍 有关等待事件的信息显示如下三个动态性能视图中： V$SESSION_WAIT ：显示会话刚刚完成等待或当前正在等待的事件。 V$SYSTEM_EVENT ：显示当前租户中所有等待事件的总数。 V$SESSION_EVENT ：类似于 V$SYSTEM_EVENT ，但显示每个会话的所有…
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.2.5 LTS

# 常见等待事件说明

更新时间：2026-04-15 17:17:00

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.2.5/zh-CN/700.reference/700.system-views/520.wait-event-description.md)  

## 等待事件介绍

有关等待事件的信息显示如下三个动态性能视图中：

- `V$SESSION_WAIT`：显示会话刚刚完成等待或当前正在等待的事件。
 - `V$SYSTEM_EVENT`：显示当前租户中所有等待事件的总数。
 - `V$SESSION_EVENT`：类似于 `V$SYSTEM_EVENT`，但显示每个会话的所有等待事件。

许多等待事件与内部实现相关联，因此可能会有更改或删除，具体以实际情况为准。

## 等待事件类型

每个等待事件都属于一类等待事件。等待事件主要分为如下几个类型：

| 等待事件所属类型名称 | 等待类别编号 ID | 描述 |
| --- | --- | --- |
| OTHER | 100 | 不属于其他类型的等待事件 |
| APPLICATION | 101 | 由于客户端代码导致的等待事件 |
| CONFIGURATION | 102 | 由于数据库或实例资源配置不足而导致的等待事件 |
| ADMINISTRATIVE | 103 | 由于数据库管理员输入命令导致用户等待的等待事件 |
| CONCURRENCY | 104 | 等待数据库内部资源的等待事件 |
| COMMIT | 105 | 在日志提交有关的等待事件 |
| IDLE | 106 | 会话处于非活动状态，等待任务的等待事件 |
| NETWORK | 107 | 与网络通信相关的等待事件 |
| USER_IO | 108 | 等待用户 I/O 的等待事件 |
| SYSTEM_IO | 109 | 等待后台进程 I/O 的等待事件 |
| CLUSTER | 111 | 与集群相关的等待事件 |

## 查看等待事件

可在系统租户下通过 SQL 语句按字母顺序显示所有等待事件及其所属的等待事件类型。示例如下：

```sql
obclient> SELECT name, wait_class FROM V$EVENT_NAME ORDER BY name;

```

### 常见等待事件

| 等待事件名称 | 描述 | 等待事件所属类型名称 | 等待事件的参数 1 | 等待事件的参数 2 | 等待事件的参数 3 |
| --- | --- | --- | --- | --- | --- |
| wait remove partition | 分区 GC 等待事务模块删除 | ADMINISTRATIVE | tenant_id | table_id | partition_id |
| wait end stmt | 语句结束等待 | CLUSTER | rollback | trans_hash_value | physic_plan_type |
| wait start stmt | 语句开启等待 | CLUSTER | trans_hash_value | physic_plan_type | participant_count |
| wait end trans | 事务提交等待 | COMMIT | rollback | trans_hash_value | participant_count |
| async rpc proxy condition wait | 上层封装的异步 RPC Wait 事件 | CONCURRENCY | address | - | - |
| dag worker condition wait | 后台 dag 线程等待事件 | CONCURRENCY | address | - | - |
| latch: alive server tracer lock wait | OBAliveServerMap 操作内存中 OBServer 状态的锁等待 | CONCURRENCY | address | number | tries |
| latch: alloc object lock wait | OceanBase malloc 内部管理小块内存的锁等待事件 | CONCURRENCY | address | number | tries |
| latch: clog cascading info lock wait | clog 副本级联模块锁的等待事件 | CONCURRENCY | address | number | tries |
| latch: clog locality lock wait | clog 内部保护 Locality 信息的锁 | CONCURRENCY | address | number | tries |
| latch: clog task lock wait | clog 模块 log_task 的锁 | CONCURRENCY | address | number | tries |
| latch: config lock wait | 配置项锁等待事件 | CONCURRENCY | address | number | tries |
| latch: default drw lock wait | DRWLock 等待事件，DRWLock 是一个适应读多写少场景的读写锁 | CONCURRENCY | address | number | tries |
| latch: default mutex wait | 缺省 MUTEX 等待事件 | CONCURRENCY | address | number | tries |
| latch: default recursive mutex wait | 缺省递归 MUTEX 等待事件 | CONCURRENCY | address | number | tries |
| latch: default spin lock wait | 缺省自旋锁等待事件 | CONCURRENCY | address | number | tries |
| latch: default spin rwlock wait | 缺省自旋读写锁等待事件 | CONCURRENCY | address | number | tries |
| latch: id map node lock wait | ID Map 等待事件，ID Map 用于把整数映射为指针 | CONCURRENCY | address | number | tries |
| latch: server maintaince lock wait | RS 进行 OBServer 操作时的锁等待 | CONCURRENCY | address | number | tries |
| latch: server status lock wait | 操作 RS 记录的 server_statuses 时的读写锁等待 | CONCURRENCY | address | number | tries |
| latch: unit manager lock wait | Unit Manager 操作数据的锁等待 | CONCURRENCY | address | number | tries |
| latch: zone infos rw lock wait | OBZoneManagerBase 操作数据的锁等待 | CONCURRENCY | address | number | tries |
| latch: zone manager maintaince lock wait | Zone Manager 操作数据的锁等待 | CONCURRENCY | address | number | tries |
| partition table updater condition wait | OBUniqTaskQueue 处理任务时的条件等待 | CONCURRENCY | address | - | - |
| rebalance task mgr condition wait | OBDRTaskMgr 处理容灾任务时的条件等待 | CONCURRENCY | address | - | - |
| reentrant thread condition wait | OBReentrantThread 处理任务时的条件等待 | CONCURRENCY | address | - | - |
| rpc session handler condition wait | 流式 RPC 等待事件 | CONCURRENCY | address | - | - |
| th worker condition wait | 多租户线程挂起等待事件 | CONCURRENCY | address | - | - |
| thread idling condition wait | RootService 空闲线程等待事件 | CONCURRENCY | address | - | - |
| sched idle | 多租户线程等待任务执行 | IDLE | wait start timestamp | - | - |
| mysql response wait client | 等待客户端返回耗时 | NETWORK | - | - | - |
| sync rpc | 同步 RPC 等待事件 | NETWORK | pcode | size | - |
| sched wait | 多租户线程因执行大查询被挂起 | SCHEDULER | req type | req start timestamp | wait start timestamp |
| bloomfilter build read | 后台 BloomFilter 创建数据读取 | SYSTEM_IO | fd | offset | size |
| db file compact read | compaction 任务数据读取 | SYSTEM_IO | fd | offset | size |
| db file compact write | compaction 任务数据写入 | SYSTEM_IO | fd | offset | size |
| db file index build read | 索引创建数据读取 | SYSTEM_IO | fd | offset | size |
| db file index build write | 索引创建数据写入 | SYSTEM_IO | fd | offset | size |
| db file migrate read | 迁移数据读取 | SYSTEM_IO | fd | offset | size |
| db file migrate write | 迁移数据写入 | SYSTEM_IO | fd | offset | size |
| memstore memory page alloc wait | MemStore 写入限速触发的等待时间 | SYSTEM_IO | cur_mem_hold | sleep_interval | cur_ts |
| db file data read | 用户数据读取 | USER_IO | fd | offset | size |
| interm result disk read | 中间结果数据读取 | USER_IO | fd | offset | size |
| interm result disk write | 中间结果数据写入 | USER_IO | fd | offset | size |
| row store disk read | SQL 算子落盘数据读取 | USER_IO | fd | offset | size |
| row store disk write | SQL 算子落盘数据写入 | USER_IO | fd | offset | size |
| build index scheduler condition wait | DDL 两次任务调度的等待时间 | CONCURRENCY | address | - | - |
| debug sync condition wait | Errsim Debug 模式下有意义，用户场景无意义 | CONCURRENCY | address | - | - |
| inner connection pool condition wait | 内部连接池条件等待 | CONCURRENCY | address | - | - |
| latch: bandwidth throttle lock wait | 带宽限流的锁等待 | CONCURRENCY | address | number | tries |
| latch: default bucket lock wait | Bucket Lock 的等待时间，未归类 | CONCURRENCY | address | number | tries |
| latch: election group trace recorder lock wait | 保护 Election Group Trace 统计信息的锁 | CONCURRENCY | address | number | tries |
| latch: group migrate lock wait | 批量迁移的锁等待 | CONCURRENCY | address | number | tries |
| latch: group migrate task lock wait | 批量迁移的任务锁等待 | CONCURRENCY | address | number | tries |
| latch: io queue lock wait | I/O queue 读取时的锁等待 | CONCURRENCY | address | number | tries |
| latch: migrate lock wait | 迁移的锁等待 | CONCURRENCY | address | number | tries |
| latch: multi tenant lock wait | 多租户管理的锁等待 | CONCURRENCY | address | number | tries |
| latch: rebuild retry list lock wait | Rebuild 任务的等待 | CONCURRENCY | address | number | tries |
| latch: session trace recorder lock wait | Session 上 Trace 记录的锁等待 | CONCURRENCY | address | number | tries |
| latch: tenant lock wait | 租户内管理的锁等待 | CONCURRENCY | address | number | tries |
| latch: timezone lock wait | 租户的 Timezone 结构锁等待，租户操作的时候会上锁 | CONCURRENCY | address | number | tries |
| oblog part mgr schema version wait | Liboblog 的等待刷新 Schema Verison 的逻辑 | CONCURRENCY | - | - | - |
| server object pool arena lock wait | 大对象缓存结构的锁等待 | USER_IO | fd | offset | size |
| async commiting wait | clog 异步提交等待事件 | COMMIT | - | - | - |
| exec inner sql wait | inner sql 等待事件 | OTHER | wait inner sql class | inner session id | - |
| sync rpc | 数据库发送同步 RPC 请求后，等待同步 RPC 返回 | NETWORK | pcode | size | - |
| sleep: wait refresh schema | 等待 Schema 刷新到指定版本 | CONFIGURATION | sleep_interval | schema_version | - |
| palf throttling sleep | 日志线程限速 | USER_IO | sleep_interval | - | - |
| palf read | 日志线程读日志 | SYSTEM_IO | fd | offset | size |
| palf write | 日志线程写日志 | SYSTEM_IO | fd | offset | size |
| das wait remote response | SQL 分布式执行中，数据库等待远程 DAS 任务执行返回结果 | NETWORK | - | - | - |
| wait for network request in queue | 数据库系统接收了某会话请求，但该请求正在等待被工作线程处理 | NETWORK | pcode | level | priority |
| retry: insufficient px worker wait | 由于 PX 线程资源不足引起的重试 | CONFIGURATION | degree of parallel | number of px workers required | the total number of idle PX workers currently |
| retry: wait GTS ready | 等待 GTS ready 引起的重试 | CLUSTER | error code | ls leader addr | ls leader port |
| retry: wait replica readable | 副本不可读引起的重试 | CLUSTER | ls_id | tablet_id | - |
| retry: wait schema cache load | 加载 schema cache 引起的重试 | CLUSTER | error code | table id | table schema version |
| retry: wait location cache load | 加载 location cache 引起的重试 | CLUSTER | error | ls_id | - |
| retry: other retry wait | 其他原因导致的重试 | CLUSTER | error | - | - |
| row lock wait | 行锁导致的等待 | APPLICATION | lock holder tx id | data seq number | holder lock time |

 上一篇 下一篇 ![有帮助](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) 咨询热线