基于湖库一体架构，统一管理结构化、半结构化与非结构化等多模态数据，一个系统承载事务处理、实时分析与 AI 工作负载。
SQL 执行阶段
更新时间：2026-04-14 11:55:54
编辑
分享
本节为您介绍 OceanBase 租户的监控指标 SQL 执行阶段，该指标细分为 13 个指标，分别为 in_parse（正在执行 SQL PARSE 的活跃会话数）、in_pl_parse（正在执行 PL PARSE 的活跃会话数）、in_plan_cache（正在访问 plan cache 的活跃会话数）、in_sql_optimize（正在执行 SQL 优化的活跃会话数）、in_sql_execution（正在执行 SQL 语句的活跃会话数）、in_px_execution（正在进行 PX SQL 并行执行的活跃会话数）、in_sequence_load（正在进行自增列或 SEQUENCE 取值的活跃会话数）、in_committing（正处于事务提交阶段的活跃会话数）、in_storage_read（正在执行存储层读的活跃会话数）、in_storage_write（正在执行存储层写的活跃会话数）、in_remote_das_execution（正在远程 DAS 执行的活跃会话数）、in_plsql_compilation（正在 PL 编译的活跃会话数）、in_plsql_execution（处于 plsql execution 状态的执行事件数）。您可指定统计范围，查询租户在单个 Zone 或 OBServer 节点的 SQL 执行阶段 数据。
in_parse
指标介绍
统计范围内，正在执行 SQL PARSE 的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_parse | sql_event_in_parse | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_parse{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.0.0 及以上、V4.2.1.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.1.0 及以上、V4.2.2.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
in_pl_parse
指标介绍
统计范围内，正在执行 PL PARSE 的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_pl_parse | sql_event_in_pl_parse | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_pl_parse{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.0.0 及以上、V4.2.1.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.1.0 及以上、V4.2.2.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
in_plan_cache
指标介绍
统计范围内，正在访问 plan cache 的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_plan_cache | sql_event_in_plan_cache | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_plan_cache{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.0.0 及以上、V4.2.1.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.1.0 及以上、V4.2.2.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
in_sql_optimize
指标介绍
统计范围内，正在执行 SQL 优化的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_sql_optimize | sql_event_in_sql_optimize | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_sql_optimize{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.0.0 及以上、V4.2.1.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.1.0 及以上、V4.2.2.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
in_sql_execution
指标介绍
统计范围内，正在执行 SQL 语句的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_sql_execution | sql_event_in_sql_execution | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_sql_execution{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.0.0 及以上、V4.2.1.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.1.0 及以上、V4.2.2.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
in_px_execution
指标介绍
统计范围内，正在进行 PX SQL 并行执行的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_px_execution | sql_event_in_px_execution | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_px_execution{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.0.0 及以上、V4.2.1.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.1.0 及以上、V4.2.2.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
in_sequence_load
指标介绍
统计范围内，正在进行自增列或 SEQUENCE 取值的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_sequence_load | sql_event_in_sequence_load | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_sequence_load{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.0.0 及以上、V4.2.1.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.1.0 及以上、V4.2.2.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
in_committing
指标介绍
统计范围内，正处于事务提交阶段的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_committing | sql_event_in_committing | - | OceanBase V4.2.1.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_committing{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.1.0 及以上、V4.2.2.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
in_storage_read
指标介绍
统计范围内，正在执行存储层读的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_storage_read | sql_event_in_storage_read | - | OceanBase V4.2.1.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_storage_read{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.1.0 及以上、V4.2.2.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
in_storage_write
指标介绍
统计范围内，正在执行存储层写的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_storage_write | sql_event_in_storage_write | - | OceanBase V4.2.1.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_storage_write{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.1.0 及以上、V4.2.2.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
in_remote_das_execution
指标介绍
统计范围内，正在远程 DAS 执行的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_remote_das_execution | sql_event_in_remote_das_execution | - | OceanBase V4.2.1.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_remote_das_execution{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.1.0 及以上、V4.2.2.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_idOceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
in_plsql_compilation
指标介绍
统计范围内，正在 PL 编译的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_plsql_compilation | sql_event_in_plsql_compilation | - | OceanBase V4.2.2.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_plsql_compilation{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
in_plsql_execution
指标介绍
统计范围内，正在 PL 执行的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_plsql_execution | sql_event_in_plsql_execution | - | OceanBase V4.2.2.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_plsql_execution{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
in_filter_rows
指标介绍
统计范围内，正在执行算子下压的活跃会话数。
指标参数说明
| 指标项 | 指标名称 | 单位 | 支持版本 |
|---|---|---|---|
| in_filter_rows | sql_event_in_filter_rows | - | OceanBase V4.2.2.0 ~ V4.3.0.0（不包括 V4.3.0.0） |
计算表达式
sum(ob_sql_event_in_filter_rows{@LABELS}) by (@GBLABELS)
采集 SQL
OceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：
SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id
