常见等待事件说明 - OceanBase 数据库 V4.4.1

常见等待事件说明

更新时间：2025-10-03 09:24:46

编辑

等待事件介绍

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

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 语句按字母顺序显示所有等待事件及其所属的等待事件类型。示例如下：

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 等待事件	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