--- title: "oceanbase.DBA_MVREF_STMT_STATS - OceanBase 数据库 V4.5.0 | OceanBase 文档中心" description: oceanbase.DBA_MVREF_STMT_STATS 说明 该视图从 V4.3.0 版本开始引入。 功能说明 视图 DBA_MVREF_STMT_STATS 用于描述刷新语句关联的信息。 字段说明 字段名称 类型 是否可以为 NULL 描述 MV_OWNER varchar(128) NO 物化视图所有者名称… --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.5.0 # oceanbase.DBA_MVREF_STMT_STATS 更新时间：2026-01-31 19:17:35 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.5.0/zh-CN/700.reference/700.system-views/400.system-view-of-mysql-mode/200.dictionary-view-of-mysql-mode/5600.o-dba_mvref_stmt_stats-of-mysql-mode.md) #### 说明 该视图从 V4.3.0 版本开始引入。 ## 功能说明 视图 `DBA_MVREF_STMT_STATS` 用于描述刷新语句关联的信息。 ## 字段说明 | **字段名称** | **类型** | **是否可以为 NULL** | **描述** | | --- | --- | --- | --- | | MV_OWNER | varchar(128) | NO | 物化视图所有者名称 | | MV_NAME | varchar(128) | NO | 物化视图名称 | | REFRESH_ID | bigint(20) | NO | 刷新 ID | | STEP | bigint(20) | NO | 步骤编号，从1开始连续编号 | | SQLID | varchar(32) | YES | SQL ID | | STMT | longtext | NO | SQL 文本 | | EXECUTION_TIME | bigint(20) | NO | SQL 执行时间，单位为秒 | | EXECUTION_PLAN | longtext | YES | 仅限内部人员排查问题使用 #### 说明 该字段仅兼容，且值默认为 NULL。 | ## 查询示例 查询刷新语句关联的信息。 ```shell obclient [test_db]> SELECT * FROM oceanbase.DBA_MVREF_STMT_STATS; ``` 查询结果如下： ```shell +----------+---------+------------+------+----------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------+ | MV_OWNER | MV_NAME | REFRESH_ID | STEP | SQLID | STMT | EXECUTION_TIME | EXECUTION_PLAN | +----------+---------+------------+------+----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------+ | test | t1_mv1 | 1415345 | 3 | 189CD424B8FA4E9A0C1620D59ED2407A | delete from `test`.`t1_mv1` where (`t1_mv1`.`cnt` = 0) | 0 | NULL | | test | t1_mv1 | 1415345 | 2 | 3D9186675C23F505AE54F4C187815E81 | insert into `test`.`t1_mv1`(`c2`,`cnt`,`cnt_c3`,`sum_c3`) select `DLT_BASIC_MV$$`.`c2` AS `c2`,`DLT_BASIC_MV$$`.`cnt` AS `cnt`,`DLT_BASIC_MV$$`.`cnt_c3` AS `cnt_c3`,(case when (`DLT_BASIC_MV$$`.`cnt_c3` = 0) then NULL else `DLT_BASIC_MV$$`.`sum_c3` end) AS `sum_c3` from (select `DLT_T$$`.`c2` AS `c2`,sum(`DLT_T$$`.`DMLFACTOR$$`) AS `cnt`,sum((`DLT_T$$`.`DMLFACTOR$$` * (case when (`DLT_T$$`.`c3` is null) then 0 else 1 end))) AS `cnt_c3`,sum((`DLT_T$$`.`DMLFACTOR$$` * `DLT_T$$`.`c3`)) AS `sum_c3` from (select `mlog$_t1`.`OLD_NEW$$` AS `OLD_NEW$$`,`mlog$_t1`.`SEQUENCE$$` AS `SEQUENCE$$`,(case when (`mlog$_t1`.`OLD_NEW$$` = 'N') then 1 else -1 end) AS `DMLFACTOR$$`,max(`mlog$_t1`.`SEQUENCE$$`) over( PARTITION BY `mlog$_t1`.`c1`) AS `MAXSEQ$$`,min(`mlog$_t1`.`SEQUENCE$$`) over( PARTITION BY `mlog$_t1`.`c1`) AS `MINSEQ$$`,`mlog$_t1`.`c2` AS `c2`,`mlog$_t1`.`c3` AS `c3` from `test`.`mlog$_t1` where (`mlog$_t1`.`ORA_ROWSCN` > 1706148016339554735) and (`mlog$_t1`.`ORA_ROWSCN` <= 1706148044936175614)) `DLT_T$$` where (((`DLT_T$$`.`OLD_NEW$$` = 'N') and (`DLT_T$$`.`SEQUENCE$$` = `DLT_T$$`.`MAXSEQ$$`)) or ((`DLT_T$$`.`OLD_NEW$$` = 'O') and (`DLT_T$$`.`SEQUENCE$$` = `DLT_T$$`.`MINSEQ$$`))) group by `DLT_T$$`.`c2`) `DLT_BASIC_MV$$` where not exists((select 1 from `test`.`t1_mv1` where (`DLT_BASIC_MV$$`.`c2` <=> `t1_mv1`.`c2`))) | 0 | NULL | | test | t1_mv1 | 1415345 | 1 | 4C4D9DBC6E35BFCBE177C343597C0197 | update `test`.`t1_mv1`,(select `DLT_T$$`.`c2` AS `c2`,sum(`DLT_T$$`.`DMLFACTOR$$`) AS `cnt`,sum((`DLT_T$$`.`DMLFACTOR$$` * (case when (`DLT_T$$`.`c3` is null) then 0 else 1 end))) AS `cnt_c3`,sum((`DLT_T$$`.`DMLFACTOR$$` * `DLT_T$$`.`c3`)) AS `sum_c3` from (select `mlog$_t1`.`OLD_NEW$$` AS `OLD_NEW$$`,`mlog$_t1`.`SEQUENCE$$` AS `SEQUENCE$$`,(case when (`mlog$_t1`.`OLD_NEW$$` = 'N') then 1 else -1 end) AS `DMLFACTOR$$`,max(`mlog$_t1`.`SEQUENCE$$`) over( PARTITION BY `mlog$_t1`.`c1`) AS `MAXSEQ$$`,min(`mlog$_t1`.`SEQUENCE$$`) over( PARTITION BY `mlog$_t1`.`c1`) AS `MINSEQ$$`,`mlog$_t1`.`c2` AS `c2`,`mlog$_t1`.`c3` AS `c3` from `test`.`mlog$_t1` where (`mlog$_t1`.`ORA_ROWSCN` > 1706148016339554735) and (`mlog$_t1`.`ORA_ROWSCN` <= 1706148044936175614)) `DLT_T$$` where (((`DLT_T$$`.`OLD_NEW$$` = 'N') and (`DLT_T$$`.`SEQUENCE$$` = `DLT_T$$`.`MAXSEQ$$`)) or ((`DLT_T$$`.`OLD_NEW$$` = 'O') and (`DLT_T$$`.`SEQUENCE$$` = `DLT_T$$`.`MINSEQ$$`))) group by `DLT_T$$`.`c2`) `DLT_BASIC_MV$$` set `t1_mv1`.`cnt` = (`t1_mv1`.`cnt` + `DLT_BASIC_MV$$`.`cnt`),`t1_mv1`.`cnt_c3` = (`t1_mv1`.`cnt_c3` + `DLT_BASIC_MV$$`.`cnt_c3`),`t1_mv1`.`sum_c3` = (case when ((`t1_mv1`.`cnt_c3` + `DLT_BASIC_MV$$`.`cnt_c3`) = 0) then NULL when (`t1_mv1`.`cnt_c3` = 0) then `DLT_BASIC_MV$$`.`sum_c3` when (`DLT_BASIC_MV$$`.`cnt_c3` = 0) then `t1_mv1`.`sum_c3` else (`t1_mv1`.`sum_c3` + `DLT_BASIC_MV$$`.`sum_c3`) end) where (`t1_mv1`.`c2` <=> `DLT_BASIC_MV$$`.`c2`) | 0 | NULL | +----------+---------+------------+------+----------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------+ ``` 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线