ASH Report

           Cluster Name: oceanbase45103
       Observer Version: OceanBase_CE 4.3.5.5 (105010032025121323-524cb9015f8e905b5361bd410f99cf97c7df6557)
  Operation System Info: Linux(6.6.117-45.oc9.x86_64)_x86_64
  User Input Begin Time: 2026-07-22 16:00:00
    User Input End Time: 2026-07-22 19:00:00
 Wr Analysis Begin Time: 2026-07-22 16:00:00
   Wr Analysis End Time: 2026-07-22 18:59:59
         Wr Data Source: oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
           Elapsed Time: 10799
       Wr Num of Sample: 160900
Average Active Sessions: 14.90

Top Active Tenants

this section lists top active tenant information
Total Samples: num of records during ash report analysis time period
Wait Event Samples: num of records when session is on wait event
On CPU Samples: num of records when session is on cpu
Avg Active Sessions: average active sessions during ash report analysis time period
% Activity: activity(cpu + wait) percentage for given tenant
Equivalent Client Load: equivalent client average active sessions during ash report analysis time period

Tenant Name	Session Type	Total Samples	Wait Event Samples	On CPU Samples	Avg Active Sessions	% Activity	Equivalent Client Load
zzlabel	FOREGROUND	92340	85670	6670	8.55	57.39%	8.05
zzlabel	BACKGROUND	68560	55190	13370	6.35	42.61%	-

Top Node Load

this section lists top node measured by DB time
IP: OceanBase instance svr_ip
Port: OceanBase instance svr_port
Total Samples: num of records during ash report analysis time period
Wait Event Samples: num of records when session is on wait event
On CPU Samples: num of records when session is on cpu
Avg Active Sessions: average active sessions during ash report analysis time period
% Activity: activity(cpu + wait) percentage for given tenant
Equivalent Client Load: equivalent client average active sessions during ash report analysis time period

IP	Port	Session Type	Total Samples	Wait Event Samples	On CPU Samples	Avg Active Sessions	% Activity	Equivalent Client Load
10.40.67.44	44103	BACKGROUND	41160	36470	4690	3.81	25.58%	-
10.40.67.44	44103	FOREGROUND	34550	31660	2890	3.20	21.47%	5.99
10.40.65.76	44103	FOREGROUND	29330	27410	1920	2.72	18.23%	5.40
10.40.66.249	44103	FOREGROUND	28450	26600	1850	2.63	17.68%	5.21
10.40.65.76	44103	BACKGROUND	10450	7210	3240	0.97	6.50%	-
10.40.66.249	44103	BACKGROUND	9790	6540	3250	0.91	6.08%	-
10.40.66.120	44103	BACKGROUND	7160	4970	2190	0.66	4.45%	-
10.40.66.120	44103	FOREGROUND	10	0	10	0.00	0.01%	0.00

Top Groups

this section lists top resource consumer groups
Group Name: resource consumer group name
Group Samples: num of sampled session activity records in the current resource group
% Activity: activity percentage for given event resource group
Avg Active Sessions: average active sessions during ash report analysis time period

Node	Group Name	Group Samples	% Activity	Program	% Program	Module	% Module	Action	% Action	Avg Active Sessions
10.40.67.44:44103	tenant:1004/group:0	75190	46.73%	T1004_SQL_CMD	21.88%	ReqWorker(Level:0)	21.19%	COM_QUERY	21.19%	3.16
				T1004_RPC_REQUEST	18.45%	ReqWorker(Level:0)	17.59%	OB_GAIS_PUSH_AUTO_INC_REQUEST	15.46%	2.30
								FastDFO	1.59%	0.24
				T1004_LogService	4.37%	LogIOWorker	4.23%	aggregate io task	4.23%	0.63
				T1004_DAG	1.25%	COMPACTION	1.25%	MAJOR_MERGE/MEDIUM_MERGE	1.14%	0.17
10.40.65.76:44103	tenant:1004/group:0	39780	24.72%	T1004_SQL_CMD	18.23%	ReqWorker(Level:0)	18.20%	COM_QUERY	18.20%	2.71
				T1004_LogService	3.22%	LogIOWorker	2.98%	aggregate io task	2.97%	0.44
				T1004_RPC_REQUEST	1.53%	ReqWorker(Level:0)	1.53%	FastDFO	1.37%	0.20
				T1004_DAG	1.37%	COMPACTION	1.37%	MAJOR_MERGE/MEDIUM_MERGE	1.15%	0.17
10.40.66.249:44103	tenant:1004/group:0	37920	23.57%	T1004_SQL_CMD	17.68%	ReqWorker(Level:0)	17.63%	COM_QUERY	17.63%	2.63
				T1004_LogService	2.86%	LogIOWorker	2.76%	aggregate io task	2.76%	0.41
				T1004_DAG	1.31%	COMPACTION	1.31%	MAJOR_MERGE/MEDIUM_MERGE	1.19%	0.18
				T1004_RPC_REQUEST	1.27%	ReqWorker(Level:0)	1.25%	FastDFO	1.04%	0.15
10.40.66.120:44103	tenant:1004/group:0	6990	4.34%	T1004_LogService	2.26%	LogIOWorker	2.05%	aggregate io task	2.05%	0.31
				T1004_DAG	1.52%	COMPACTION	1.52%	MAJOR_MERGE/MEDIUM_MERGE	1.21%	0.18

Slot Begin Time	Slot Count	Action Key	Action Samples	% Activity	Avg Active Sessions
2026-07-22 16:00:00(+360s)	4750	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	860	18.11%	2.39
2026-07-22 16:00:00(+360s)	4750	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	800	16.84%	2.22
2026-07-22 16:00:00(+360s)	4750	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	700	14.74%	1.94
2026-07-22 16:00:00(+360s)	4750	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	470	9.89%	1.31
2026-07-22 16:00:00(+360s)	4750	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	240	5.05%	0.67
2026-07-22 16:00:00(+360s)	4750	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	180	3.79%	0.50
2026-07-22 16:00:00(+360s)	4750	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	140	2.95%	0.39
2026-07-22 16:00:00(+360s)	4750	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	90	1.90%	0.25
2026-07-22 16:00:00(+360s)	4750	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	80	1.68%	0.22
2026-07-22 16:00:00(+360s)	4750	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	80	1.68%	0.22
2026-07-22 16:00:00(+360s)	4750	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	70	1.47%	0.19
2026-07-22 16:00:00(+360s)	4750	10.40.67.44:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	20	0.42%	0.06
2026-07-22 16:00:00(+360s)	4750	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	10	0.21%	0.03
2026-07-22 16:00:00(+360s)	4750	10.40.65.76:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	10	0.21%	0.03
2026-07-22 16:00:00(+360s)	4750	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	10	0.21%	0.03
2026-07-22 16:06:00(+1080s)	12310	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	2430	19.74%	2.25
2026-07-22 16:06:00(+1080s)	12310	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	2380	19.33%	2.20
2026-07-22 16:06:00(+1080s)	12310	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	2320	18.85%	2.15
2026-07-22 16:06:00(+1080s)	12310	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	830	6.74%	0.77
2026-07-22 16:06:00(+1080s)	12310	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	700	5.69%	0.65
2026-07-22 16:06:00(+1080s)	12310	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	540	4.39%	0.50
2026-07-22 16:06:00(+1080s)	12310	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	450	3.66%	0.42
2026-07-22 16:06:00(+1080s)	12310	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	360	2.92%	0.33
2026-07-22 16:06:00(+1080s)	12310	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	300	2.44%	0.28
2026-07-22 16:06:00(+1080s)	12310	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	210	1.71%	0.19
2026-07-22 16:06:00(+1080s)	12310	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	210	1.71%	0.19
2026-07-22 16:06:00(+1080s)	12310	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	20	0.16%	0.02
2026-07-22 16:06:00(+1080s)	12310	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	10	0.08%	0.01
2026-07-22 16:24:00(+1080s)	42620	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	9690	22.74%	8.97
2026-07-22 16:24:00(+1080s)	42620	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	9460	22.20%	8.76
2026-07-22 16:24:00(+1080s)	42620	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	8280	19.43%	7.67
2026-07-22 16:24:00(+1080s)	42620	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	8160	19.15%	7.56
2026-07-22 16:24:00(+1080s)	42620	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	1330	3.12%	1.23
2026-07-22 16:24:00(+1080s)	42620	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	990	2.32%	0.92
2026-07-22 16:24:00(+1080s)	42620	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	920	2.16%	0.85
2026-07-22 16:24:00(+1080s)	42620	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	680	1.59%	0.63
2026-07-22 16:24:00(+1080s)	42620	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	660	1.55%	0.61
2026-07-22 16:24:00(+1080s)	42620	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	560	1.31%	0.52
2026-07-22 16:24:00(+1080s)	42620	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	350	0.82%	0.32
2026-07-22 16:42:00(+1080s)	22620	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	4820	21.31%	4.46
2026-07-22 16:42:00(+1080s)	22620	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	4560	20.16%	4.22
2026-07-22 16:42:00(+1080s)	22620	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	4100	18.13%	3.80
2026-07-22 16:42:00(+1080s)	22620	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	4010	17.73%	3.71
2026-07-22 16:42:00(+1080s)	22620	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	990	4.38%	0.92
2026-07-22 16:42:00(+1080s)	22620	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	790	3.49%	0.73
2026-07-22 16:42:00(+1080s)	22620	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	690	3.05%	0.64
2026-07-22 16:42:00(+1080s)	22620	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	590	2.61%	0.55
2026-07-22 16:42:00(+1080s)	22620	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	320	1.42%	0.30
2026-07-22 16:42:00(+1080s)	22620	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	270	1.19%	0.25
2026-07-22 16:42:00(+1080s)	22620	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	200	0.88%	0.18
2026-07-22 16:42:00(+1080s)	22620	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	10	0.04%	0.01
2026-07-22 17:00:00(+1080s)	19200	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	3310	17.24%	3.06
2026-07-22 17:00:00(+1080s)	19200	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	3230	16.82%	2.99
2026-07-22 17:00:00(+1080s)	19200	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	3160	16.46%	2.93
2026-07-22 17:00:00(+1080s)	19200	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	2430	12.66%	2.25
2026-07-22 17:00:00(+1080s)	19200	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	800	4.17%	0.74
2026-07-22 17:00:00(+1080s)	19200	10.40.65.76:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	710	3.70%	0.66
2026-07-22 17:00:00(+1080s)	19200	10.40.67.44:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	700	3.65%	0.65
2026-07-22 17:00:00(+1080s)	19200	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	660	3.44%	0.61
2026-07-22 17:00:00(+1080s)	19200	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	600	3.12%	0.56
2026-07-22 17:00:00(+1080s)	19200	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	580	3.02%	0.54
2026-07-22 17:00:00(+1080s)	19200	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	550	2.87%	0.51
2026-07-22 17:00:00(+1080s)	19200	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	380	1.98%	0.35
2026-07-22 17:00:00(+1080s)	19200	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	260	1.35%	0.24
2026-07-22 17:00:00(+1080s)	19200	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	220	1.15%	0.20
2026-07-22 17:00:00(+1080s)	19200	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	190	0.99%	0.18
2026-07-22 17:18:00(+1080s)	13110	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1760	13.43%	1.63
2026-07-22 17:18:00(+1080s)	13110	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1720	13.12%	1.59
2026-07-22 17:18:00(+1080s)	13110	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1460	11.14%	1.35
2026-07-22 17:18:00(+1080s)	13110	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	1030	7.86%	0.95
2026-07-22 17:18:00(+1080s)	13110	10.40.65.76:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	970	7.40%	0.90
2026-07-22 17:18:00(+1080s)	13110	10.40.67.44:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	910	6.94%	0.84
2026-07-22 17:18:00(+1080s)	13110	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	800	6.10%	0.74
2026-07-22 17:18:00(+1080s)	13110	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	600	4.58%	0.56
2026-07-22 17:18:00(+1080s)	13110	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	510	3.89%	0.47
2026-07-22 17:18:00(+1080s)	13110	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	450	3.43%	0.42
2026-07-22 17:18:00(+1080s)	13110	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	440	3.36%	0.41
2026-07-22 17:18:00(+1080s)	13110	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	400	3.05%	0.37
2026-07-22 17:18:00(+1080s)	13110	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	340	2.59%	0.32
2026-07-22 17:18:00(+1080s)	13110	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	290	2.21%	0.27
2026-07-22 17:18:00(+1080s)	13110	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	200	1.53%	0.18
2026-07-22 17:36:00(+1080s)	6730	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	3010	44.73%	2.79
2026-07-22 17:36:00(+1080s)	6730	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	1610	23.92%	1.49
2026-07-22 17:36:00(+1080s)	6730	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	670	9.96%	0.62
2026-07-22 17:36:00(+1080s)	6730	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	270	4.01%	0.25
2026-07-22 17:36:00(+1080s)	6730	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	120	1.78%	0.11
2026-07-22 17:36:00(+1080s)	6730	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	110	1.63%	0.10
2026-07-22 17:36:00(+1080s)	6730	10.40.67.44:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	100	1.49%	0.09
2026-07-22 17:36:00(+1080s)	6730	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	70	1.04%	0.07
2026-07-22 17:36:00(+1080s)	6730	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	70	1.04%	0.07
2026-07-22 17:36:00(+1080s)	6730	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	60	0.89%	0.06
2026-07-22 17:36:00(+1080s)	6730	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	40	0.59%	0.04
2026-07-22 17:36:00(+1080s)	6730	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	40	0.59%	0.04
2026-07-22 17:36:00(+1080s)	6730	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	30	0.45%	0.03
2026-07-22 17:54:00(+1080s)	4140	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1840	44.44%	1.70
2026-07-22 17:54:00(+1080s)	4140	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	1350	32.61%	1.25
2026-07-22 17:54:00(+1080s)	4140	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	510	12.32%	0.47
2026-07-22 17:54:00(+1080s)	4140	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	110	2.66%	0.10
2026-07-22 18:30:00(+1080s)	7310	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1510	20.66%	1.40
2026-07-22 18:30:00(+1080s)	7310	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1400	19.15%	1.30
2026-07-22 18:30:00(+1080s)	7310	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1390	19.02%	1.29
2026-07-22 18:30:00(+1080s)	7310	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	490	6.70%	0.45
2026-07-22 18:30:00(+1080s)	7310	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	490	6.70%	0.45
2026-07-22 18:30:00(+1080s)	7310	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	430	5.88%	0.40
2026-07-22 18:30:00(+1080s)	7310	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	290	3.97%	0.27
2026-07-22 18:30:00(+1080s)	7310	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	260	3.56%	0.24
2026-07-22 18:30:00(+1080s)	7310	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	170	2.33%	0.16
2026-07-22 18:30:00(+1080s)	7310	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	170	2.33%	0.16
2026-07-22 18:30:00(+1080s)	7310	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	110	1.50%	0.10
2026-07-22 18:48:00(+719s)	28110	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	6020	21.42%	8.37
2026-07-22 18:48:00(+719s)	28110	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	5890	20.95%	8.19
2026-07-22 18:48:00(+719s)	28110	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	5640	20.06%	7.84
2026-07-22 18:48:00(+719s)	28110	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	4920	17.50%	6.84
2026-07-22 18:48:00(+719s)	28110	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	870	3.10%	1.21
2026-07-22 18:48:00(+719s)	28110	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	820	2.92%	1.14
2026-07-22 18:48:00(+719s)	28110	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	760	2.70%	1.06
2026-07-22 18:48:00(+719s)	28110	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	370	1.32%	0.52
2026-07-22 18:48:00(+719s)	28110	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	300	1.07%	0.42
2026-07-22 18:48:00(+719s)	28110	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	220	0.78%	0.31
2026-07-22 18:48:00(+719s)	28110	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	200	0.71%	0.28
2026-07-22 18:48:00(+719s)	28110	10.40.65.76:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	160	0.57%	0.22
2026-07-22 18:48:00(+719s)	28110	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	160	0.57%	0.22
2026-07-22 18:48:00(+719s)	28110	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	160	0.57%	0.22
2026-07-22 18:48:00(+719s)	28110	10.40.67.44:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	100	0.36%	0.14

Top Foreground DB Time

This section lists top foreground db time categorized by event
Event Name: comprise wait event and on cpu event
Event Samples: num of sampled session activity records
% Activity: activity percentage for given event
Avg Active Sessions: average active sessions during ash report analysis time period

Node	Event Name	Wait Class	Event Samples	Avg Active Sessions	% Activity
10.40.67.44:44103	latch: auto increment GAIS lock wait	CONCURRENCY	11560	1.07	7.18%
	sync tx commiting wait	COMMIT	10300	0.95	6.40%
	tx commiting wait	COMMIT	4540	0.42	2.82%
	ON CPU	NULL	2890	0.27	1.80%
	wait dtl data receive response	NETWORK	2360	0.22	1.47%
	sleep: lock for read need wait for concurrency control	CONCURRENCY	900	0.08	0.56%
	db file data read	USER_IO	850	0.08	0.53%
	exec inner sql wait	OTHER	630	0.06	0.39%
	wait in request queue	CONFIGURATION	450	0.04	0.28%
	row lock wait	APPLICATION	50	0.01	0.03%
10.40.65.76:44103	sync rpc	NETWORK	10990	1.02	6.83%
	sync tx commiting wait	COMMIT	9020	0.83	5.61%
	tx commiting wait	COMMIT	3640	0.34	2.26%
	ON CPU	NULL	1920	0.18	1.19%
	wait dtl data receive response	NETWORK	1710	0.16	1.06%
	sleep: lock for read need wait for concurrency control	CONCURRENCY	1080	0.10	0.67%
	db file data read	USER_IO	640	0.06	0.40%
	sync get gts timestamp wait	NETWORK	160	0.01	0.10%
	mysql response wait client	IDLE	80	0.01	0.05%
	row lock wait	APPLICATION	50	0.01	0.03%
	wait in request queue	CONFIGURATION	40	0.00	0.03%
10.40.66.249:44103	sync rpc	NETWORK	11330	1.05	7.04%
	sync tx commiting wait	COMMIT	7900	0.73	4.91%
	tx commiting wait	COMMIT	3500	0.32	2.17%
	wait dtl data receive response	NETWORK	1910	0.18	1.19%
	ON CPU	NULL	1850	0.17	1.15%
	sleep: lock for read need wait for concurrency control	CONCURRENCY	930	0.09	0.58%
	db file data read	USER_IO	720	0.07	0.45%
	sync get gts timestamp wait	NETWORK	170	0.02	0.11%
	wait in request queue	CONFIGURATION	80	0.01	0.05%

Top Background DB Time

this section lists top DB Time for background sessions
Program: process name for background sessions
Event Name: comprise wait event and on cpu event
Event Samples: num of sampled session activity records
% Activity: activity percentage for given event
Avg Active Sessions: average active sessions during ash report analysis time period

Node	Program	Module	Action	Event Name	Wait Class	Event Samples	% Activity	Avg Active Sessions
10.40.67.44:44103	T1004_RPC_REQUEST	ReqWorker(Level:0)	OB_GAIS_PUSH_AUTO_INC_REQUEST	latch: auto increment GAIS lock wait	CONCURRENCY	23490	14.60%	2.17
	T1004_LogService	LogIOWorker	aggregate io task	palf write	SYSTEM_IO	6710	4.17%	0.62
	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	ON CPU	NULL	1580	0.98%	0.15
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	db file data read	USER_IO	1260	0.78%	0.12
	T1004_RPC_REQUEST	ReqWorker(Level:0)	OB_GAIS_PUSH_AUTO_INC_REQUEST	exec inner sql wait	OTHER	1150	0.71%	0.11
	T1004_RPC_REQUEST	LOCAL INNER SQL EXEC	NULL_INNER_SQL	sync tx commiting wait	COMMIT	1080	0.67%	0.10
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	sleep: lock for read need wait for concurrency control	CONCURRENCY	660	0.41%	0.06
	T1004_RPC_REQUEST	ReqWorker(Level:0)	OB_PX_FAST_INIT_SQC	ON CPU	NULL	570	0.35%	0.05
	T1004_SQL_CMD	LOCAL INNER SQL EXEC	NULL_INNER_SQL	sync tx commiting wait	COMMIT	530	0.33%	0.05
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	ON CPU	NULL	520	0.32%	0.05
	T1004_RPC_REQUEST	ReqWorker(Level:0)	OB_GAIS_PUSH_AUTO_INC_REQUEST	ON CPU	NULL	240	0.15%	0.02
	T1004_RPC_REQUEST	LOCAL INNER SQL EXEC	NULL_INNER_SQL	ON CPU	NULL	200	0.12%	0.02
10.40.65.76:44103	T1004_LogService	LogIOWorker	aggregate io task	palf write	SYSTEM_IO	4750	2.95%	0.44
	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	ON CPU	NULL	1600	0.99%	0.15
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	db file data read	USER_IO	850	0.53%	0.08
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	sleep: lock for read need wait for concurrency control	CONCURRENCY	820	0.51%	0.08
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	ON CPU	NULL	450	0.28%	0.04
	T1004_LogService	LogReplayService	TRANS_SERVICE	ON CPU	NULL	270	0.17%	0.03
	T1004_DAG	COMPACTION	MINOR_EXECUTE	ON CPU	NULL	230	0.14%	0.02
10.40.66.249:44103	T1004_LogService	LogIOWorker	aggregate io task	palf write	SYSTEM_IO	4350	2.70%	0.40
	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	ON CPU	NULL	1680	1.04%	0.16
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	db file data read	USER_IO	660	0.41%	0.06
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	sleep: lock for read need wait for concurrency control	CONCURRENCY	520	0.32%	0.05
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	ON CPU	NULL	390	0.24%	0.04
10.40.66.120:44103	T1004_LogService	LogIOWorker	aggregate io task	palf write	SYSTEM_IO	3250	2.02%	0.30
	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	ON CPU	NULL	1430	0.89%	0.13
	T1004_TimerWK	TimerWK	UNDEFINED	db file compact read	SYSTEM_IO	380	0.24%	0.04
	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	db file data read	USER_IO	310	0.19%	0.03
	T1004_LogService	LogReplayService	TRANS_SERVICE	ON CPU	NULL	250	0.15%	0.02
	T1004_DAG	COMPACTION	MINI_MERGE	db file compact read	SYSTEM_IO	230	0.14%	0.02

Top Sessions

this section lists top Active Sessions with the largest wait event and SQL_ID
Session ID: user session id
% Activity: represents the load on the database caused by this session
Avg Active Sessions: average active sessions during ash report analysis time period
Event Name: comprise wait event and on cpu event
% Event: represents the activity load of the event on the database
% SQL ID: represents the activity load of the event on the database
Sql Executions: represents the execution count of the SQL_ID

Node	Session ID	Program	% Activity	Avg Active Sessions	Event Name	Wait Class	% Event	SQL ID	Plan Hash	% SQL ID	Sql Executions
10.40.67.44:44103	4501187	T1004_SQL_CMD	0.13%	0.02	latch: auto increment GAIS lock wait	CONCURRENCY	0.06%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	0.04%	6
10.40.67.44:44103	4492132	T1004_SQL_CMD	0.12%	0.02	sync tx commiting wait	COMMIT	0.04%	D0A4F18E0349F173B94F895D1FB95B5F	0	0.04%	7
10.40.67.44:44103	4038894	T1004_SQL_CMD	0.12%	0.02	sync tx commiting wait	COMMIT	0.06%	D0A4F18E0349F173B94F895D1FB95B5F	0	0.06%	10
10.40.65.76:44103	3952311	T1004_SQL_CMD	0.11%	0.02	sync rpc	NETWORK	0.07%	6ABAB80F52D977C0E0E769696F3FD45D	3290318591324336132	0.04%	7
10.40.67.44:44103	4270579	T1004_SQL_CMD	0.11%	0.02	sync tx commiting wait	COMMIT	0.06%	D0A4F18E0349F173B94F895D1FB95B5F	0	0.06%	10
10.40.67.44:44103	4535402	T1004_SQL_CMD	0.11%	0.02	sync tx commiting wait	COMMIT	0.04%	D0A4F18E0349F173B94F895D1FB95B5F	0	0.04%	6
10.40.66.249:44103	4238797	T1004_SQL_CMD	0.10%	0.01	sync tx commiting wait	COMMIT	0.04%	D0A4F18E0349F173B94F895D1FB95B5F	0	0.04%	7
10.40.65.76:44103	4264333	T1004_SQL_CMD	0.10%	0.01	sync tx commiting wait	COMMIT	0.06%	D0A4F18E0349F173B94F895D1FB95B5F	0	0.06%	9
10.40.67.44:44103	4038890	T1004_SQL_CMD	0.10%	0.01	latch: auto increment GAIS lock wait	CONCURRENCY	0.03%	6ABAB80F52D977C0E0E769696F3FD45D	3290318591324336132	0.02%	3
10.40.67.44:44103	3967938	T1004_SQL_CMD	0.09%	0.01	latch: auto increment GAIS lock wait	CONCURRENCY	0.04%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	0.02%	3
10.40.67.44:44103	4238790	T1004_SQL_CMD	0.09%	0.01	sync tx commiting wait	COMMIT	0.06%	D0A4F18E0349F173B94F895D1FB95B5F	0	0.06%	9
10.40.67.44:44103	3979949	T1004_SQL_CMD	0.09%	0.01	sync tx commiting wait	COMMIT	0.04%	D0A4F18E0349F173B94F895D1FB95B5F	0	0.04%	6
10.40.67.44:44103	4286498	T1004_SQL_CMD	0.09%	0.01	sync tx commiting wait	COMMIT	0.04%	D0A4F18E0349F173B94F895D1FB95B5F	0	0.04%	6
10.40.67.44:44103	4251087	T1004_SQL_CMD	0.09%	0.01	latch: auto increment GAIS lock wait	CONCURRENCY	0.04%	6ABAB80F52D977C0E0E769696F3FD45D	3290318591324336132	0.02%	3
10.40.67.44:44103	4217792	T1004_SQL_CMD	0.09%	0.01	latch: auto increment GAIS lock wait	CONCURRENCY	0.04%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	0.03%	5

Top IO Bandwidth

This section lists the top io bandwidth from the perspective of SQL and background tasks
Node: The IP address and port number of the observer
Program Module Action / SQL ID: Program Module Action represent the type of background tasks, which is only effective in background tasks. And SQL ID is only effective in foreground tasks
Plan Hash: Numeric representation of the current SQL plan, which is only effective in foreground tasks.
IOPS: Average IO requests executed per second
IO Size: The total read or write size(MB) of background task or SQL
IO Bandwidth: Average IO size(MB) consumed per second
Type: read or write
Object ID: The tablet_id with the highest read or write bytes
% Object ID: The ratio of the tablet_id with the highest read or write bytes to the total bytes of tablet_ids in entire background task or SQL

Node	Program Module Action / SQL ID	Plan Hash	Type	IOPS	IO Size(MB)	IO Bandwidth(MB/s)	Object ID	% Object ID
10.40.67.44:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_read	85.37	1027.17	18.31	0	100.00%
10.40.67.44:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_write	37.78	972.30	17.33	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/TX_TABLE_MERGE	0	disk_read	47.47	17.80	14.08	0	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/TX_TABLE_MERGE	0	disk_read	39.35	9.12	11.96	0	100.00%
10.40.67.44:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_write	120.59	694.02	11.51	0	100.00%
10.40.67.44:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_read	223.93	467.00	7.75	0	100.00%
10.40.65.76:44103	E2DE94349ED1508B628FE3DFBA40487F	7431865554498282460	disk_read	514.33	2.46	7.43	202191	100.00%
10.40.67.44:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_read	11.39	74223.64	6.21	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_read	10.82	74471.09	5.75	0	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_read	11.33	72130.24	5.74	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_read	11.85	65494.34	5.56	0	100.00%
10.40.67.44:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_write	2.33	37852.34	3.17	0	100.00%
10.40.65.76:44103	1E173267938C82173BC2CF8F1A0B616E	7431865554498282460	disk_read	259.16	0.35	3.05	0	60.01%
10.40.65.76:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_write	2.68	37811.76	3.01	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_write	2.37	38347.27	2.96	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_write	2.27	34811.76	2.96	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_write	33.09	1692.38	2.79	0	100.00%
10.40.67.44:44103	T1004_BFBuildTask/BFBuildTask/BloomFilterBuild	0	disk_read	0.92	9540.00	1.84	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_read	59.35	1071.81	1.77	0	100.00%
10.40.65.76:44103	T1004_LogService/LogIOWorker/	0	disk_write	381.05	222.81	1.76	0	100.00%
10.40.66.249:44103	T1004_BFBuildTask/BFBuildTask/BloomFilterBuild	0	disk_read	0.85	22560.00	1.71	0	100.00%
10.40.67.44:44103	T1004_LogService/LogIOWorker/aggregate io task	0	disk_write	322.25	37864.14	1.50	0	100.00%
10.40.66.249:44103	T1004_LogService/LogIOWorker/aggregate io task	0	disk_write	308.60	29850.04	1.46	0	100.00%
10.40.65.76:44103	T1004_LogService/LogIOWorker/aggregate io task	0	disk_write	291.43	29266.91	1.38	0	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_write	11.26	1180.23	1.19	0	100.00%
10.40.66.120:44103	T1004_LogService/LogIOWorker/aggregate io task	0	disk_write	241.71	28503.36	1.14	0	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_read	21.44	970.95	0.98	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/BATCH_FREEZE	0	disk_read	8.56	66.51	0.86	0	100.00%
10.40.65.76:44103	T1004_BFBuildTask/BFBuildTask/BloomFilterBuild	0	disk_read	0.35	2920.00	0.69	0	100.00%
10.40.65.76:44103	3DD85E2829BF814BD529E1A7ECE1B10D	7431865554498282460	disk_read	45.70	0.13	0.61	202194	100.00%
10.40.67.44:44103	T1004_DAG/COMPACTION/TX_TABLE_MERGE	0	disk_read	2.13	817.98	0.60	0	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_read	1.28	2979.99	0.59	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/BATCH_FREEZE	0	disk_write	0.39	44.22	0.57	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_write	0.71	733.40	0.51	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_read	2.03	658.87	0.46	0	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_write	0.28	1858.40	0.37	0	100.00%
10.40.67.44:44103	T1004_DAG/COMPACTION/TX_TABLE_MERGE	0	disk_write	0.73	411.76	0.30	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_read	3.06	752.09	0.26	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_write	2.52	1235.66	0.23	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_read	5.49	1200.81	0.23	0	100.00%
10.40.65.76:44103	BAD403F7FB82F91AB958154E2D5875CE	18231308322961799645	disk_read	13.47	0.14	0.19	202498	100.00%
10.40.66.249:44103	436B7D91382306E4054AE9A99C10A846	4024070737857038369	disk_read	11.14	18.75	0.17	202462	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_write	0.95	435.08	0.15	0	100.00%
10.40.67.44:44103	T1004_TimerWK/TimerWK/TabletGCTask	0	disk_read	188.28	17.75	0.08	0	100.00%
10.40.67.44:44103	T1004_RPC_REQUEST/ReqWorker(Level:0)/OB_LOG_LEARNER_REQ	0	disk_read	5.42	2.81	0.08	0	100.00%
10.40.66.249:44103	A32245251CE4B6EA3D5F0D8F2F12B555	18231308322961799645	disk_read	5.70	1.10	0.08	202478	100.00%
10.40.67.44:44103	T1004_RPC_REQUEST/ReqWorker(Level:0)/OB_GET_GTS_REQUEST	0	disk_read	4.31	20.61	0.06	0	100.00%

Top Blocking Sessions

Blocking session activity percentages are calculated with respect to waits on enqueues, latches and "buffer busy" only.
'% Activity' represents the load on the database caused by a particular blocking session.
'# Avg Active Sessions' shows the number of ASH samples in which the blocking session was found active.

Blocking Session ID	% Activity	Avg Active Sessions	Holder User	Holder TX ID	Holder SQL ID	Event Caused	% Event	XIDs	Top Waitting SQL ID	% SQL ID

Top Latchs

this section lists top latches
Latch Wait Event: event that waiting for latch
Event Samples: num of sampled session activity records
% Activity: activity percentage for given event
Avg Active Sessions: average active sessions during ash report analysis time period

Latch Wait Event	Event Samples	% Activity	Avg Active Sessions
latch: auto increment GAIS lock wait	35050	21.78%	3.25
latch: tablet bucket lock wait	10	0.01%	0.00

Top DB Objects

With respect to Application, Cluster, User I/O and buffer busy waits only.
Object ID: tablet_id of the database table.
Avg Active Sessions: average active sessions during ash report analysis time period.
% Activity:the load on the database caused by accessing the databsae object.
Execution Count:represents how many executions involve this object
Event:When accessing the object, the corresponding Top waiting events (up to 5 are printed).
% Event:The percentage of the corresponding Top wait events when accessing the object (up to 5 events are printed).
SQL ID:the SQL ID with the highest load when accessing the object and in the wait event.
%SQL ID/Module:The percentage of SQL ID or Module with the highest load in this wait event when accessing the object.
Object Name (Type/ Partition Name):the name and type/partition_name of the database object being accessed

Node Address	Tenant ID	Object ID	Avg Active Sessions	% Activity	Execution Count	Event	% Event	SQL ID	%SQL ID/Module	Object Name (Type/Partition Name)
10.40.67.44:44103	1004	202201	0.01	0.07%	12	ON CPU	0.07%	41F1ACA07326B154880B224D7E8C92CA	0.03%	db58_zzlabel.label_core
	1004	1152921504606851012	0.01	0.07%	12	ON CPU	0.07%	2978BDEB9F5B56381B6194B262A36C8F	0.01%	db58_zzlabel.user_label_relation.unique_index
						db file data read	0.01%	68E91E95307599949E83AF352518A31A	0.01%
	1004	182	0.01	0.07%	11	ON CPU	0.07%	11BC02B00E5D559A2D0A0C7A3576A113	0.04%	oceanbase.__all_auto_increment
	1004	1152921504606850798	0.01	0.05%	8	sleep: lock for read need wait for concurrency control	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p173)
						db file data read	0.01%	73690A81DF7ADC3F72F124C9105F168F	0.01%
						ON CPU	0.01%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	0.01%
	1004	1152921504606850645	0.01	0.04%	6	sleep: lock for read need wait for concurrency control	0.04%	325B3ABB9AD3AAA360CF70373A17FCF7	0.03%	db58_zzlabel.label_product.uniq_productid_labelid(p20)
	1004	1152921504606850783	0.01	0.04%	6	db file data read	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p158)
	1004	1152921504606850729	0.01	0.04%	6	db file data read	0.03%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p104)
	1004	1152921504606850849	0.01	0.04%	6	db file data read	0.02%	8E2E0AA9F00B424D170DE0402491EE32	0.02%	db58_zzlabel.label_product.uniq_productid_labelid(p224)
						sleep: lock for read need wait for concurrency control	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.02%
	1004	202282	0.01	0.04%	6	ON CPU	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product(p77)
						db file data read	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
	1004	1152921504606850660	0.01	0.04%	6	sleep: lock for read need wait for concurrency control	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p35)
						db file data read	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
						sleep: lock for read need wait for concurrency control	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
						ON CPU	0.01%	E07E0E7BF48DF9F632220BEAD3E5F5D4	0.01%
						sleep: lock for read need wait for concurrency control	0.01%	8E2E0AA9F00B424D170DE0402491EE32	0.01%
	1004	1152921504606850708	0.01	0.03%	5	sleep: lock for read need wait for concurrency control	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p83)
	1004	202246	0.01	0.03%	5	ON CPU	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product(p41)
	1004	1152921504606850732	0.01	0.03%	5	sleep: lock for read need wait for concurrency control	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.02%	db58_zzlabel.label_product.uniq_productid_labelid(p107)
	1004	202429	0.01	0.03%	5	ON CPU	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product(p224)
	1004	1152921504606850858	0.01	0.03%	5	db file data read	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p233)
	1004	1152921504606850627	0.01	0.03%	5	db file data read	0.02%	73690A81DF7ADC3F72F124C9105F168F	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p2)
	1004	1152921504606850741	0.01	0.03%	5	sleep: lock for read need wait for concurrency control	0.02%	73690A81DF7ADC3F72F124C9105F168F	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p116)
	1004	1152921504606850717	0.01	0.03%	5	sleep: lock for read need wait for concurrency control	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p92)
						db file data read	0.01%	8E2E0AA9F00B424D170DE0402491EE32	0.01%
						db file data read	0.01%	8E2E0AA9F00B424D170DE0402491EE32	0.01%
						db file data read	0.01%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	0.01%
						db file data read	0.01%	73690A81DF7ADC3F72F124C9105F168F	0.01%
	1004	202225	0.01	0.03%	5	ON CPU	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product(p20)
						db file data read	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
						sleep: lock for read need wait for concurrency control	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
						ON CPU	0.01%	19D77D3D2FE2C17A7B780EB1A4981DAE	0.01%
						sleep: lock for read need wait for concurrency control	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
						sleep: lock for read need wait for concurrency control	0.01%	5F76C602C3B3E12F10C080272B0B3E4B	0.01%
						ON CPU	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
						sleep: lock for read need wait for concurrency control	0.01%	8E2E0AA9F00B424D170DE0402491EE32	0.01%
10.40.65.76:44103	1004	1152921504606850865	0.01	0.04%	7	sleep: lock for read need wait for concurrency control	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.02%	db58_zzlabel.label_product.uniq_productid_labelid(p240)
	1004	1152921504606850781	0.01	0.04%	7	ON CPU	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.02%	db58_zzlabel.label_product.uniq_productid_labelid(p156)
						sleep: lock for read need wait for concurrency control	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
	1004	1152921504606850829	0.01	0.04%	7	ON CPU	0.02%	6ABAB80F52D977C0E0E769696F3FD45D	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p204)
						db file data read	0.01%	8E2E0AA9F00B424D170DE0402491EE32	0.01%
						db file data read	0.01%	5F76C602C3B3E12F10C080272B0B3E4B	0.01%
						sleep: lock for read need wait for concurrency control	0.01%	8E2E0AA9F00B424D170DE0402491EE32	0.01%
	1004	1152921504606850700	0.01	0.04%	6	sleep: lock for read need wait for concurrency control	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.02%	db58_zzlabel.label_product.uniq_productid_labelid(p75)
	1004	1152921504606850637	0.01	0.04%	6	sleep: lock for read need wait for concurrency control	0.03%	5F76C602C3B3E12F10C080272B0B3E4B	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p12)
	1004	1152921504606850835	0.01	0.04%	6	db file data read	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p210)
	1004	1152921504606850796	0.01	0.04%	6	db file data read	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p171)
						sleep: lock for read need wait for concurrency control	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
						db file data read	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
						sleep: lock for read need wait for concurrency control	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
						ON CPU	0.01%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	0.01%
						ON CPU	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
						ON CPU	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
	1004	202461	0.01	0.03%	5	ON CPU	0.03%	9C7BD866CF9F4869C732A9FF9BD7B8A9	0.03%	db58_zzlabel.label_show
	1004	1152921504606850649	0.01	0.03%	5	sleep: lock for read need wait for concurrency control	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p24)
	1004	1152921504606850628	0.01	0.03%	5	sleep: lock for read need wait for concurrency control	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.03%	db58_zzlabel.label_product.uniq_productid_labelid(p3)
	1004	202370	0.01	0.03%	5	ON CPU	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product(p165)
						sleep: lock for read need wait for concurrency control	0.01%	8E2E0AA9F00B424D170DE0402491EE32	0.01%
						db file data read	0.01%	73690A81DF7ADC3F72F124C9105F168F	0.01%

Activity Over Time

this section lists time slot information during the analysis period.
The numbers in parentheses represent the time (in seconds) that has passed since the beginning and end stages.
Slot Begin Time: current slot's begin time. current slot end with next slot begin time.
Event Name: comprise wait event and on cpu event.
Event Samples: num of sampled session activity records.
% Activity: activity percentage for given event.
Avg Active Sessions: average active sessions during ash report analysis time period.

Slot Begin Time	Slot Count	Event Name	Wait Class	Event Samples	% Activity	Avg Active Sessions
2026-07-22 16:00:00(+360s)	4750	sync tx commiting wait	COMMIT	910	19.16%	2.53
		ON CPU	NULL	720	15.16%	2.00
		palf write	SYSTEM_IO	620	13.05%	1.72
		latch: auto increment GAIS lock wait	CONCURRENCY	580	12.21%	1.61
		sync rpc	NETWORK	480	10.11%	1.33
2026-07-22 16:06:00	12310	sync tx commiting wait	COMMIT	2610	21.20%	2.42
		palf write	SYSTEM_IO	1950	15.84%	1.81
		ON CPU	NULL	1720	13.97%	1.59
		tx commiting wait	COMMIT	1650	13.40%	1.53
		latch: auto increment GAIS lock wait	CONCURRENCY	880	7.15%	0.81
2026-07-22 16:24:00	42620	latch: auto increment GAIS lock wait	CONCURRENCY	11810	27.71%	10.94
		sync rpc	NETWORK	8610	20.20%	7.97
		sync tx commiting wait	COMMIT	7970	18.70%	7.38
		palf write	SYSTEM_IO	3860	9.06%	3.57
		tx commiting wait	COMMIT	3620	8.49%	3.35
2026-07-22 16:42:00	22620	latch: auto increment GAIS lock wait	CONCURRENCY	5720	25.29%	5.30
		sync tx commiting wait	COMMIT	4940	21.84%	4.57
		sync rpc	NETWORK	3670	16.23%	3.40
		palf write	SYSTEM_IO	3020	13.35%	2.80
		ON CPU	NULL	2040	9.02%	1.89
2026-07-22 17:00:00	19200	ON CPU	NULL	4360	22.71%	4.04
		latch: auto increment GAIS lock wait	CONCURRENCY	3560	18.54%	3.30
		sync tx commiting wait	COMMIT	2940	15.31%	2.72
		sync rpc	NETWORK	2810	14.63%	2.60
		palf write	SYSTEM_IO	2080	10.83%	1.93
2026-07-22 17:18:00	13110	ON CPU	NULL	4960	37.83%	4.59
		palf write	SYSTEM_IO	1760	13.43%	1.63
		sync tx commiting wait	COMMIT	1350	10.30%	1.25
		db file data read	USER_IO	1310	9.99%	1.21
		latch: auto increment GAIS lock wait	CONCURRENCY	660	5.03%	0.61
2026-07-22 17:36:00	6730	latch: auto increment GAIS lock wait	CONCURRENCY	2200	32.69%	2.04
		sync tx commiting wait	COMMIT	980	14.56%	0.91
		ON CPU	NULL	950	14.12%	0.88
		palf write	SYSTEM_IO	810	12.04%	0.75
		tx commiting wait	COMMIT	730	10.85%	0.68
2026-07-22 17:54:00	4140	latch: auto increment GAIS lock wait	CONCURRENCY	1870	45.17%	1.73
		sync tx commiting wait	COMMIT	860	20.77%	0.80
		palf write	SYSTEM_IO	500	12.08%	0.46
		ON CPU	NULL	360	8.70%	0.33
		exec inner sql wait	OTHER	140	3.38%	0.13
2026-07-22 18:30:00	7310	palf write	SYSTEM_IO	1660	22.71%	1.54
		tx commiting wait	COMMIT	1650	22.57%	1.53
		sync tx commiting wait	COMMIT	1110	15.19%	1.03
		ON CPU	NULL	920	12.59%	0.85
		wait dtl data receive response	NETWORK	460	6.29%	0.43
2026-07-22 18:48:00(+719s)	28110	latch: auto increment GAIS lock wait	CONCURRENCY	7420	26.40%	10.32
		sync tx commiting wait	COMMIT	5510	19.60%	7.66
		sync rpc	NETWORK	5360	19.07%	7.46
		palf write	SYSTEM_IO	2800	9.96%	3.89
		ON CPU	NULL	1900	6.76%	2.64

Top Execution Phase

this section lists top phases of execution, such as SQL, PL/SQL, STORAGE, etc.

Session Type	Phase of Execution	Active Samples	% Activity	SQL_ID	% SQL_ID
FOREGROUND	IN_SQL_EXECUTION	78130	48.56%	D0A4F18E0349F173B94F895D1FB95B5F	17.05%
	IN_COMMITTING	39020	24.25%	D0A4F18E0349F173B94F895D1FB95B5F	16.99%
	IN_STORAGE_READ	6750	4.20%	325B3ABB9AD3AAA360CF70373A17FCF7	2.46%
	IN_CHECK_TX_STATUS	2910	1.81%	325B3ABB9AD3AAA360CF70373A17FCF7	1.32%
	IN_PLAN_CACHE	670	0.42%	F473D8895D6EF4C707F27316AA9C2108	0.14%
	IN_STORAGE_WRITE	640	0.40%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	0.11%
	IN_RPC_ENCODE	200	0.12%	73690A81DF7ADC3F72F124C9105F168F	0.03%
	IN_EXTRACT_QUERY_RANGE	120	0.07%	F473D8895D6EF4C707F27316AA9C2108	0.03%
	IN_PARSE	100	0.06%	061710EB39A660899FD038929B3B9A23	0.01%
	IN_DUPLICATE_CONFLICT_RESOLVE	50	0.03%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	0.03%
	IN_RESOLVE	40	0.03%	FAF0B5463BBDBCCA9F8584234D5908C2	0.01%
	IN_CHECK_ROW_CONFLICTION	30	0.02%	19D77D3D2FE2C17A7B780EB1A4981DAE	0.01%
	IN_CONNECTION_MGR	30	0.02%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	0.01%
	IN_SQL_OPTIMIZE	10	0.01%	3DD85E2829BF814BD529E1A7ECE1B10D	0.01%
	IN_FILTER_ROWS	10	0.01%	58C1844BDE6652B0BDE864CDF1EE625F	0.01%
BACKGROUND	IN_SQL_EXECUTION	6570	4.08%	8E2E0AA9F00B424D170DE0402491EE32	2.23%
	IN_PX_EXECUTION	6430	4.00%	8E2E0AA9F00B424D170DE0402491EE32	2.19%
	IN_STORAGE_READ	5750	3.57%	8E2E0AA9F00B424D170DE0402491EE32	2.02%
	IN_CHECK_TX_STATUS	2010	1.25%	8E2E0AA9F00B424D170DE0402491EE32	0.72%
	IN_COMMITTING	2000	1.24%	1D0BA376E273B9D622641124D8C59264	1.12%
	IN_RPC_DECODE	620	0.39%	8E2E0AA9F00B424D170DE0402491EE32	0.17%
	IN_CONNECTION_MGR	90	0.06%	8E2E0AA9F00B424D170DE0402491EE32	0.03%
	IN_STORAGE_WRITE	90	0.06%	11BC02B00E5D559A2D0A0C7A3576A113	0.04%
	IN_RPC_ENCODE	40	0.03%		0.01%
	IN_DUPLICATE_CONFLICT_RESOLVE	20	0.01%	7C895CA99D111B696EE33230828BDCC2	0.01%
	IN_PLAN_CACHE	20	0.01%	7F33FD22651F99E8AB2BAC5428623BCD	0.01%
	IN_PARSE	20	0.01%	11BC02B00E5D559A2D0A0C7A3576A113	0.01%
	IN_REMOTE_DAS_EXECUTION	10	0.01%	436B7D91382306E4054AE9A99C10A846	0.01%
	IN_EXTRACT_QUERY_RANGE	10	0.01%	858015B92843B43D99CA77541C4C2592	0.01%

Top IO Events

This section lists the top io event from the perspective of SQL and background tasks
Node: The IP address and port number of the observer
Program Module Action / SQL ID: Program Module Action represent the type of background tasks, which is only effective in background tasks. And SQL ID is only effective in foreground tasks
Plan Hash: Numeric representation of the current SQL plan, which is only effective in foreground tasks
IO Event Samples: The total samples of io wait event during task execution.
%IO Event Samples: The proportion of total io wait event samples among all sampled points
Top Event: The top io wait event name.
IO Type: The type of io wait event.
% EVENT: activity percentage for the io wait event.
Enqueue Time: The total time(in seconds) spent queuing for I/O requests.
Device Time: The total time (in seconds) spent executing I/O requests on the device.
Callback Time: The total time (in seconds) spent executing callbacks for I/O requests.

Node	Program Module Action / SQL ID	Plan Hash	IO Event Samples	%IO Event Samples	Top Event	IO Type	% EVENT	Enqueue Time(S)	Device Time(S)	Callback Time(S)
10.40.67.44:44103	T1004_LogService/LogIOWorker/aggregate io task	0	6710	4.17%	palf write	SYSTEM_IO	4.17%	633.35	8827.53	0.00
10.40.65.76:44103	T1004_LogService/LogIOWorker/aggregate io task	0	4750	2.95%	palf write	SYSTEM_IO	2.95%	297.83	6352.02	0.00
10.40.66.249:44103	T1004_LogService/LogIOWorker/aggregate io task	0	4350	2.70%	palf write	SYSTEM_IO	2.70%	224.63	5834.04	0.00
10.40.66.120:44103	T1004_LogService/LogIOWorker/aggregate io task	0	3250	2.02%	palf write	SYSTEM_IO	2.02%	27.08	3670.46	0.00
10.40.67.44:44103	8E2E0AA9F00B424D170DE0402491EE32	2029748640274024157	800	0.50%	db file data read	USER_IO	0.50%	607.77	551.29	1.48
10.40.66.120:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	510	0.32%	db file data read	USER_IO	0.19%	4.52	358.35	0.00
10.40.65.76:44103	8E2E0AA9F00B424D170DE0402491EE32	2029748640274024157	430	0.27%	db file data read	USER_IO	0.27%	322.04	263.75	0.57
10.40.66.249:44103	8E2E0AA9F00B424D170DE0402491EE32	2029748640274024157	360	0.22%	db file data read	USER_IO	0.22%	231.22	278.45	0.71
10.40.66.120:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	340	0.21%	db file compact read	SYSTEM_IO	0.14%	158.33	61.53	30.76
10.40.67.44:44103	325B3ABB9AD3AAA360CF70373A17FCF7	11013570064090107881	280	0.17%	db file data read	USER_IO	0.17%	114.19	285.07	0.38
10.40.65.76:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	250	0.15%	db file compact read	SYSTEM_IO	0.09%	8.84	192.63	0.00
10.40.67.44:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	250	0.15%	db file compact read	SYSTEM_IO	0.11%	0.92	238.91	0.00
10.40.66.249:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	230	0.14%	db file compact read	SYSTEM_IO	0.11%	13.71	222.49	0.00
10.40.65.76:44103	325B3ABB9AD3AAA360CF70373A17FCF7	11013570064090107881	220	0.14%	db file data read	USER_IO	0.14%	128.78	195.60	0.24
10.40.66.249:44103	F473D8895D6EF4C707F27316AA9C2108	14928774872249983864	180	0.11%	db file data read	USER_IO	0.11%	138.70	116.35	0.14
10.40.67.44:44103	73690A81DF7ADC3F72F124C9105F168F	2029748640274024157	150	0.09%	db file data read	USER_IO	0.09%	135.45	81.07	0.25
10.40.67.44:44103	F473D8895D6EF4C707F27316AA9C2108	14928774872249983864	140	0.09%	db file data read	USER_IO	0.09%	112.33	89.70	0.15
10.40.66.249:44103	C535FF13485F55FD455B52BF6F4381A5	9505620650660437702	120	0.07%	db file data read	USER_IO	0.07%	95.29	75.85	0.22
10.40.67.44:44103	71575E9916254271F17308EE09753D86	7873854860140674618	110	0.07%	db file data read	USER_IO	0.07%	7.12	144.89	0.21
10.40.65.76:44103	73690A81DF7ADC3F72F124C9105F168F	2029748640274024157	110	0.07%	db file data read	USER_IO	0.07%	85.83	73.00	0.14
10.40.66.249:44103	95FBCF0AC71561BC8A700D195FE6A5FA	2029748640274024157	110	0.07%	db file data read	USER_IO	0.07%	23.98	115.36	0.20
10.40.67.44:44103	C535FF13485F55FD455B52BF6F4381A5	9505620650660437702	110	0.07%	db file data read	USER_IO	0.07%	77.39	79.55	0.30

Top SQL Statement Types

this section lists top sql statement type.
SQL Statement Type: SQL statement types such as SELECT or UPDATE
Total Samples: num of records during ash report analysis time period
% Event: activity percentage of records when session is on wait event
% On CPU: activity percentage of records when session is on cpu
% Activity: activity(cpu + wait) percentage for given tenant
Node: the server address where the statement was executed

SQL Statement Type	Total Samples	% Activity	Sampled Executions	Node	% Node	% On CPU	% Event
T_NONE	59050	36.70%	2613	10.40.67.44:44103	22.38%	2.22%	20.16%
				10.40.65.76:44103	5.01%	1.75%	3.26%
				10.40.66.249:44103	4.91%	1.77%	3.14%
				10.40.66.120:44103	4.40%	1.35%	3.04%
T_INSERT	35910	22.32%	1270	10.40.67.44:44103	7.89%	0.14%	7.75%
				10.40.66.249:44103	7.31%	0.14%	7.17%
				10.40.65.76:44103	7.11%	0.11%	7.00%
T_VARIABLE_SET	27800	17.28%	1054	10.40.67.44:44103	6.55%	0.14%	6.41%
				10.40.65.76:44103	5.69%	0.08%	5.61%
				10.40.66.249:44103	5.03%	0.12%	4.91%
T_SELECT	24020	14.93%	958	10.40.67.44:44103	6.12%	2.00%	4.12%
				10.40.65.76:44103	4.59%	1.20%	3.39%
				10.40.66.249:44103	4.18%	1.06%	3.11%
T_END_TRANS	13030	8.10%	607	10.40.67.44:44103	3.77%	0.04%	3.73%
				10.40.66.249:44103	2.17%	0.01%	2.16%

Top SQL with Top Events

This Section lists the SQL statements that accounted for the highest percentages event.
Plan Hash: Numeric representation of the current SQL plan
Active Samples: num of samples for top current SQL
% Activity: activity percentage for given SQL ID
Sampled Executions: represents the number of times the current SQL execution has been sampled
Top Event: top event name for current SQL plan
% Event: activity percentage for current SQL plan
Top Operator/ExecPhase: top operator name or execution phase for current event
% Operator/ExecPhase: activity percentage for given operator

SQL ID	Plan Hash	Active Samples	% Activity	Sampled Executions	Top Event	% Event	Top Operator/ExecPhase	% Operator/ExecPhase	SQL Text
D0A4F18E0349F173B94F895D1FB95B5F	0	27570	17.14%	2757	sync tx commiting wait	16.92%	UNDEFINED	16.92%	UNDEFINED
					ON CPU	0.21%	UNDEFINED	0.21%
					wait in request queue	0.01%	UNDEFINED	0.01%
6ABAB80F52D977C0E0E769696F3FD45D	3290318591324336132	16290	10.12%	1629	sync rpc	6.64%	0:DISTRIBUTED INSERT	6.64%	INSERT INTO label_product(`product_id`, `label_id`, `cr
					latch: auto increment GAIS lock wait	3.21%	0:DISTRIBUTED INSERT	3.21%
					exec inner sql wait	0.14%	0:DISTRIBUTED INSERT	0.14%
					tx commiting wait	0.07%	0:DISTRIBUTED INSERT	0.07%
					ON CPU	0.04%	0:DISTRIBUTED INSERT	0.04%
69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	11940	7.42%	1194	sync rpc	4.36%	0:DISTRIBUTED INSERT_UP	4.36%	INSERT INTO label_product (id, product_id, label_id, la
					latch: auto increment GAIS lock wait	2.63%	0:DISTRIBUTED INSERT_UP	2.63%
					exec inner sql wait	0.18%	0:DISTRIBUTED INSERT_UP	0.18%
					ON CPU	0.17%	0:DISTRIBUTED INSERT_UP	0.17%
					db file data read	0.04%	0:DISTRIBUTED INSERT_UP	0.04%
FFFCA4D67EA0A788813031B8BBC3B329	0	11210	6.97%	1121	tx commiting wait	6.95%	UNDEFINED	6.95%	UNDEFINED
					ON CPU	0.02%	UNDEFINED	0.02%
8E2E0AA9F00B424D170DE0402491EE32	2029748640274024157	7170	4.46%	707	wait dtl data receive response	1.85%	0:PX COORDINATOR	1.85%	SELECT * FROM label_product WHERE product_id in (?,?,?,
					db file data read	0.99%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.99%
					sleep: lock for read need wait for concurrency control	0.72%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.72%
					ON CPU	0.70%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.35%
					wait dtl transmit message response	0.07%	1:EXCHANGE OUT DISTR::EX10000	0.07%
325B3ABB9AD3AAA360CF70373A17FCF7	11013570064090107881	4590	2.85%	459	sleep: lock for read need wait for concurrency control	1.32%	0:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	1.32%	SELECT * FROM label_product WHERE product_id in (?)
					ON CPU	1.06%	0:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	1.06%
					db file data read	0.37%	0:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.37%
					wait in request queue	0.11%	0:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.11%
19D77D3D2FE2C17A7B780EB1A4981DAE	8894128478548303855	3000	1.86%	300	sync rpc	1.22%	0:DISTRIBUTED INSERT_UP	1.22%	INSERT INTO label_product (id, product_id, label_id, la
					latch: auto increment GAIS lock wait	0.57%	0:DISTRIBUTED INSERT_UP	0.57%
					ON CPU	0.03%	0:DISTRIBUTED INSERT_UP	0.03%
					exec inner sql wait	0.02%	0:DISTRIBUTED INSERT_UP	0.02%
					sync get gts timestamp wait	0.01%	0:DISTRIBUTED INSERT_UP	0.01%
73690A81DF7ADC3F72F124C9105F168F	2029748640274024157	1890	1.18%	186	wait dtl data receive response	0.53%	0:PX COORDINATOR	0.53%	SELECT * FROM label_product WHERE product_id in (?,?)
					db file data read	0.22%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.22%
					ON CPU	0.20%	0:PX COORDINATOR	0.09%
					sleep: lock for read need wait for concurrency control	0.17%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.17%
					wait dtl transmit message response	0.03%	1:EXCHANGE OUT DISTR::EX10000	0.03%
1D0BA376E273B9D622641124D8C59264	7727410139361190945	1650	1.02%	165	sync tx commiting wait	1.00%	IN_COMMITTING	1.00%	UNDEFINED
					ON CPU	0.03%	IN_COMMITTING	0.02%

Top SQL with Top Operator

This Section lists the SQL statements that accounted for the highest percentages of sampled session activity with sql operator
Plan Hash: Numeric representation of the current SQL plan
Active Samples: num of samples for top current SQL
% Activity: activity percentage for given SQL ID
Sampled Executions: represents the number of times the current SQL execution has been sampled
Top Operator: top operator name for current SQL plan
% Operator: activity percentage for given operator
Top Event: top event name for current operator
% Event: activity percentage for given event

SQL ID	Plan Hash	Active Samples	% Activity	Sampled Executions	Top Operator	% Operator	Top Event	% Event	SQL Text
6ABAB80F52D977C0E0E769696F3FD45D	3290318591324336132	16290	10.12%	1629	0:DISTRIBUTED INSERT	10.11%	sync rpc	6.64%	INSERT INTO label_product(`product_id`, `label_id`, `cr
					1:EXPRESSION	0.01%	row lock wait	0.01%
69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	11940	7.42%	1194	0:DISTRIBUTED INSERT_UP	7.42%	sync rpc	4.36%	INSERT INTO label_product (id, product_id, label_id, la
					1:EXPRESSION	0.01%	row lock wait	0.01%
8E2E0AA9F00B424D170DE0402491EE32	2029748640274024157	7090	4.41%	700	0:PX COORDINATOR	2.21%	wait dtl data receive response	1.85%	SELECT * FROM label_product WHERE product_id in (?,?,?,
					3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	2.06%	db file data read	0.99%
					1:EXCHANGE OUT DISTR::EX10000	0.11%	wait dtl transmit message response	0.07%
					2:PX PARTITION ITERATOR	0.03%	ON CPU	0.03%
325B3ABB9AD3AAA360CF70373A17FCF7	11013570064090107881	4590	2.85%	459	0:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	2.85%	sleep: lock for read need wait for concurrency control	1.32%	SELECT * FROM label_product WHERE product_id in (?)
19D77D3D2FE2C17A7B780EB1A4981DAE	8894128478548303855	3000	1.86%	300	0:DISTRIBUTED INSERT_UP	1.86%	sync rpc	1.22%	INSERT INTO label_product (id, product_id, label_id, la
					1:EXPRESSION	0.01%	row lock wait	0.01%
73690A81DF7ADC3F72F124C9105F168F	2029748640274024157	1870	1.16%	184	0:PX COORDINATOR	0.65%	wait dtl data receive response	0.53%	SELECT * FROM label_product WHERE product_id in (?,?)
					3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.47%	db file data read	0.22%
					1:EXCHANGE OUT DISTR::EX10000	0.04%	wait dtl transmit message response	0.03%
					2:PX PARTITION ITERATOR	0.01%	ON CPU	0.01%

Top PL/SQL Procedures

"PL/SQL Entry Subprogram" represents the application's top-level entry-point(procedure, function, trigger, package initialization) into PL/SQL.
"PL/SQL Current Subprogram" is the pl/sql subprogram being executed at the point of sampling. If the value is "SQL", it represents the percentage of time spent executing SQL for the particular plsql entry subprogram.
"PL/SQL Entry Subprogram" represents the application's top-level subprogram name

PLSQL Entry Subprogram	% Activity	PLSQL Current Subprogram	% Current

Complete List of SQL Text And Status

This Section lists the SQL statements and status, but some top sql statements may be eliminated
First Load Time: plan generation time
Plan Cache Hit Rate: Percentage of plan cache hits
AVG RPC: Average number of RPC calls per execution
AVG Partition: Average number of partitions accessed per execution
Route Miss Rate: Percentage of partition routing errors
AVG Disk Reads: Average bytes of disk data read per execution
Muti Query Rate: Percentage of multi-statement queries
Muti Query Batch Rate: Percentage of batch executions
AVG Error: Average number of errors per request
Full Table Scan Rate: Percentage of full table scans
AVG Retry: Average number of retries per execution
Executions: Number of executions
AVG Elapsed Time: Average execution time per execution(nanoseconds)

SQL ID	Plan Hash	First Load Time	SQL Text	Plan Cache Hit Rate	AVG RPC	AVG Partition	Route Miss Rate	AVG Disk Reads	Muti Query Rate	Muti Query Batch Rate	Full Table Scan Rate	Executions	AVG Elapsed Time
69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	2026-07-22 22:00:09	INSERT INTO label_product (id, product_id, label_id, label_value, is_delete, create_time) VALUES (?,?,?,?,?,?) on duplicate key update is_delete=VALUES(is_delete),label_value=VALUES(label_value)	100.00%	1.48	3.00	0.00%	0.03	100.00%	0.00%	0.00%	4162326	7111796.58
6ABAB80F52D977C0E0E769696F3FD45D	3290318591324336132	2026-07-22 22:00:09	INSERT INTO label_product(`product_id`, `label_id`, `create_time`, `is_delete`, `label_value`, `id`) VALUES (?, ?, ?, ?, ?, ?)	100.13%	1.96	3.00	0.00%	0.00	100.13%	0.00%	0.00%	250067	65335818.48
858015B92843B43D99CA77541C4C2592	7633853560152394845	2026-07-17 22:00:05	SELECT VALUE FROM __all_sys_stat WHERE ZONE = ? AND NAME = ? AND TENANT_ID = ? FOR UPDATE	100.00%	1.00	1.00	100.00%	0.00	0.00%	0.00%	0.00%	287196	48942911.95
19D77D3D2FE2C17A7B780EB1A4981DAE	8894128478548303855	2026-07-22 22:00:09	INSERT INTO label_product (id, product_id, label_id, label_value, is_delete, create_time) VALUES (?,?,?,?,?,?),(?,?,?,?,?,?) on duplicate key update is_delete=VALUES(is_delete),label_value=VALUES(label_value)	100.02%	1.91	3.00	0.00%	0.03	100.02%	0.00%	0.00%	530212	18060269.03
8E2E0AA9F00B424D170DE0402491EE32	2029748640274024157	2026-07-23 02:00:06	SELECT * FROM label_product WHERE product_id in (?,?,?,?,?)	100.00%	3.56	9.92	0.00%	0.00	100.00%	0.00%	0.00%	1009339	8993732.99
325B3ABB9AD3AAA360CF70373A17FCF7	11013570064090107881	2026-07-23 10:52:13	SELECT * FROM label_product WHERE product_id in (?)	100.00%	0.00	2.00	0.00%	0.18	100.00%	0.00%	0.00%	5280660	1138100.54
95FBCF0AC71561BC8A700D195FE6A5FA	2029748640274024157	2026-07-21 15:00:35	SELECT * FROM label_product WHERE product_id in (?,?,?,?)	100.00%	3.37	7.95	0.00%	0.00	100.00%	0.00%	0.00%	214904	8627304.71
71575E9916254271F17308EE09753D86	7873854860140674618	2026-07-23 11:06:13	SELECT * FROM info_label_relation WHERE info_id in(?)	100.00%	0.00	1.00	0.00%	0.23	100.00%	0.00%	0.00%	1220330	1495645.43
C535FF13485F55FD455B52BF6F4381A5	9505620650660437702	2026-07-23 08:31:17	select * from info_label_relation where info_id =? and label_id in (?) and source_type=? and source_key=?	100.00%	0.00	2.00	0.00%	0.27	100.00%	0.00%	0.00%	1066013	780508.25
1E173267938C82173BC2CF8F1A0B616E	7431865554498282460	2026-07-23 02:00:12	SELECT * FROM info_label_relation WHERE info_id in(?,?)	100.00%	2.67	2.00	0.00%	0.00	100.00%	0.00%	0.00%	116452	7064914.18
F473D8895D6EF4C707F27316AA9C2108	14928774872249983864	2026-07-23 10:04:20	SELECT * FROM label_user WHERE ?=? and uid in (?)	100.00%	0.00	2.00	0.00%	0.02	100.00%	0.00%	0.00%	4322349	145808.53
73690A81DF7ADC3F72F124C9105F168F	2029748640274024157	2026-07-23 10:08:03	SELECT * FROM label_product WHERE product_id in (?,?)	100.00%	2.41	4.00	0.00%	0.00	100.00%	0.00%	0.00%	62382	3372161.42
3DD85E2829BF814BD529E1A7ECE1B10D	7431865554498282460	2026-07-23 11:05:20	SELECT * FROM info_label_relation WHERE info_id in(?,?,?,?,?,?,?,?)	99.96%	3.82	7.89	0.00%	0.01	100.00%	0.00%	0.00%	5185	38469010.70
58C1844BDE6652B0BDE864CDF1EE625F	6058988316246793068	2026-07-22 19:39:06	SELECT * FROM label_core WHERE is_delete=? ORDER BY sort_id LIMIT ?,?	100.00%	0.00	1.00	0.00%	0.00	100.00%	0.00%	100.00%	336	22165.59
BAD403F7FB82F91AB958154E2D5875CE	18231308322961799645	2026-07-23 10:15:06	SELECT * FROM label_user WHERE ?=? and uid in (?,?,?,?,?,?,?,?,?,?,?,?)	99.91%	3.95	22.11	0.00%	0.01	100.00%	0.00%	0.00%	2159	3225.80
858015B92843B43D99CA77541C4C2592	123034349000847138	2026-07-17 22:00:01	SELECT VALUE FROM __all_sys_stat WHERE ZONE = ? AND NAME = ? AND TENANT_ID = ? FOR UPDATE	100.00%	1.30	0.25	0.00%	0.00	0.00%	0.00%	0.00%	1420	3393.39
11BC02B00E5D559A2D0A0C7A3576A113	7727410139361190945	2026-07-23 10:58:49	UPDATE __all_auto_increment SET sync_value = ?, sequence_value = ?, gmt_modified = now(6) WHERE tenant_id=? AND sequence_key=? AND column_id=? AND truncate_version=?	100.00%	0.00	1.00	0.00%	0.00	0.00%	0.00%	0.00%	90756	45.60
A32245251CE4B6EA3D5F0D8F2F12B555	18231308322961799645	2026-07-23 10:16:15	SELECT * FROM label_user WHERE ?=? and uid in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)	99.49%	3.89	34.77	0.00%	0.10	100.00%	0.00%	0.00%	389	6864.16
436B7D91382306E4054AE9A99C10A846	4024070737857038369	2026-07-23 10:54:32	select lt.* from label_core lc left join label_type lt on lc.type_id = lt.type_id where lc.label_id = ? and lc.is_delete = ?	99.97%	1.00	2.00	0.00%	0.00	100.00%	0.00%	0.00%	2942	270.42
73690A81DF7ADC3F72F124C9105F168F	11013570064090107881	2026-07-23 10:08:12	SELECT * FROM label_product WHERE product_id in (?,?)	99.20%	0.00	2.00	0.00%	1.02	100.00%	0.00%	0.00%	250	1152.48
E2DE94349ED1508B628FE3DFBA40487F	7431865554498282460	2026-07-22 19:42:55	SELECT * FROM info_label_relation WHERE info_id in(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)	86.67%	3.93	45.07	0.00%	3.73	100.00%	0.00%	0.00%	15	19065.00
1E173267938C82173BC2CF8F1A0B616E	7873854860140674618	2026-07-23 02:00:47	SELECT * FROM info_label_relation WHERE info_id in(?,?)	99.39%	0.00	1.00	0.00%	0.33	100.00%	0.00%	0.00%	496	488.53

End of Report