--- title: "oceanbase.DBA_OB_TTL_TASK_HISTORY - OceanBase 数据库 V4.6.0 | OceanBase 文档中心" description: oceanbase.DBA_OB_TTL_TASK_HISTORY 说明 该视图从 V4.6.0 版本开始引入。 功能描述 视图 oceanbase.DBA_OB_TTL_TASK_HISTORY 用于展示 SQL 模式下当前租户 TTL 任务的执行历史。 字段说明 字段 类型 是否为 NULL 描述 TABLE_N… --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.6.0 # oceanbase.DBA_OB_TTL_TASK_HISTORY 更新时间：2026-07-13 22:33:21 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.6.0/zh-CN/700.reference/700.system-views/400.system-view-of-mysql-mode/200.dictionary-view-of-mysql-mode/15670.o-dba_ob_ttl_task_history-of-mysql-mode.md) #### 说明 该视图从 V4.6.0 版本开始引入。 ## 功能描述 视图 `oceanbase.DBA_OB_TTL_TASK_HISTORY` 用于展示 SQL 模式下当前租户 TTL 任务的执行历史。 ## 字段说明 | 字段 | 类型 | 是否为 NULL | 描述 | | --- | --- | --- | --- | | TABLE_NAME | varchar(256) | NO | 表名 | | TABLE_ID | bigint(20) | NO | 表 ID | | TASK_ID | bigint(20) | NO | 当前批次任务的 ID | | START_TIME | timestamp(6) | NO | 任务的开始时间 | | MODIFIED_TIME | timestamp(6) | NO | 行的更新时间 | | TRIGGER_TYPE | varchar(8) | NO | 任务触发类型： - `PERIODIC`：系统定期触发 - `USER`：用户手动触发 | | STATUS | varchar(10) | NO | 任务的状态： - `CANCELED`：任务被取消 - `FINISHED`：任务已结束 - `SKIP`：未达到可执行状态，跳过本轮次执行 - `FAILED`：任务执行失败 | | RET_CODE | varchar(512) | NO | 任务结束时返回的错误码 | | TASK_TYPE | varchar(10) | NO | TTL 任务类型： - `NORMAL`：租户级别信息展示 - `COMPACTION`：表级任务类型，通过 Compaction 做过期数据删除 | ## 查询示例 用户租户查询本租户 TTL 任务的执行历史。 ```shell obclient(root@mysql001)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_TTL_TASK_HISTORY; ``` 查询结果如下： ```shell +------------+----------+---------+----------------------------+----------------------------+--------------+----------+------------+------------+ | TABLE_NAME | TABLE_ID | TASK_ID | START_TIME | MODIFIED_TIME | TRIGGER_TYPE | STATUS | RET_CODE | TASK_TYPE | +------------+----------+---------+----------------------------+----------------------------+--------------+----------+------------+------------+ | ttl_tbl1 | 500008 | 3 | 2026-03-11 11:05:08.212740 | 2026-03-11 11:05:08.221139 | USER | FINISHED | OB_SUCCESS | COMPACTION | | ttl_tbl1 | 500008 | 2 | 2026-03-11 10:41:23.018283 | 2026-03-11 10:41:23.025330 | USER | FINISHED | OB_SUCCESS | COMPACTION | | ttl_tbl1 | 500008 | 1 | 2026-03-11 10:37:22.934703 | 2026-03-11 10:37:22.945876 | USER | FINISHED | OB_SUCCESS | COMPACTION | | ttl_tbl2 | 500009 | 3 | 2026-03-11 11:05:08.224464 | 2026-03-11 11:05:08.229749 | USER | FINISHED | OB_SUCCESS | COMPACTION | | ttl_tbl2 | 500009 | 2 | 2026-03-11 10:41:23.028355 | 2026-03-11 10:41:23.033363 | USER | FINISHED | OB_SUCCESS | COMPACTION | | ttl_tbl2 | 500009 | 1 | 2026-03-11 10:37:22.952009 | 2026-03-11 10:37:22.958490 | USER | FINISHED | OB_SUCCESS | COMPACTION | | NULL | -1 | 1 | 2026-03-11 10:37:18.061066 | 2026-03-11 10:37:22.970234 | USER | FINISHED | OB_SUCCESS | COMPACTION | | NULL | -1 | 2 | 2026-03-11 10:41:13.700826 | 2026-03-11 10:41:23.045337 | USER | FINISHED | OB_SUCCESS | COMPACTION | | NULL | -1 | 3 | 2026-03-11 11:05:05.235833 | 2026-03-11 11:05:08.242563 | USER | FINISHED | OB_SUCCESS | COMPACTION | +------------+----------+---------+----------------------------+----------------------------+--------------+----------+------------+------------+ 9 rows in set ``` ## 相关视图或文档 - 查看本租户 TTL 任务的执行情况：[DBA_OB_TTL_TASKS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005684661) - 查看所有用户租户的 TTL 任务： - [CDB_OB_TTL_TASKS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005684093) - [CDB_OB_TTL_TASK_HISTORY](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005683961) - [使用 TTL（Time To Live）功能](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005682772) 上一篇 下一篇 ![有帮助](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) 咨询热线