---
title: "oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY - OceanBase Database AI V4.6.2 | OceanBase 文档中心"
description: oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY 功能描述 视图 DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY 为租户级视图，展示当前租户已完成的逻辑表（Logical Table）后台删除任务历史。 字段说明 字段 类型 是否为 N…
image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*inJjSpyNOjUAAAAAHtAAAAgAeiGDAQ/original) OceanBase Database AIV 4.6.2

# oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY

更新时间：2026-08-13 19:27:48

[编辑](https://github.com/oceanbase/oceanbase-database-ai/edit/V4.6.2/zh-CN/700.reference/700.system-views/400.system-view-of-mysql-mode/200.dictionary-view-of-mysql-mode/5740.o-dba_ob_agent_db_background_task_history-of-mysql-mode.md)  

## 功能描述

视图 `DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY` 为租户级视图，展示当前租户已完成的逻辑表（Logical Table）后台删除任务历史。

## 字段说明

| 字段 | 类型 | 是否为 NULL | 描述 |
| --- | --- | --- | --- |
| DATABASE_NAME | varchar(128) | NO | 数据库名字。 |
| COLLECTION_NAME | varchar(256) | NO | Collection 名字。 |
| NAMESPACE_NAME | varchar(256) | NO | Namespace 名字。 |
| LTABLE_NAME | varchar(256) | NO | 逻辑表名字。   - `NAMESPACE_DELETE` 场景值为空字符串（`''`）。 - `HOT_NAMESPACE_EXPIRE` 场景值为空字符串（`''`）。 |
| OPERATION_TYPE | varchar(32) | NO | 操作类型，取值如下：   - `LTABLE_DELETE` - `NAMESPACE_DELETE` - `HOT_NAMESPACE_EXPIRE` |
| OPERATION_STATUS | varchar(32) | NO | 操作状态，取值如下：   - `COMPLETED` - `FAILED` |
| START_TIME | timestamp | NO | 任务开始时间。 |
| FINISH_TIME | timestamp | NO | 任务结束时间。 |
| ELAPSED_TIME | bigint | NO | 删除任务耗时，单位为微秒。 |
| TOTAL_DELETED_ROWS | bigint | NO | - `LTABLE_DELETE` / `NAMESPACE_DELETE` 场景：表示当前该逻辑表已删除的 `<collection_id>_kv_data_table` 物理表的行数。 - `HOT_NAMESPACE_EXPIRE` 场景：值为 `0`。 |
| ORIGINAL_NAME | varchar(256) | NO | 被删除对象的原始名称。 |
| RET_CODE | varchar(512) | NO | 错误码名字。 |

## 查询示例

用户租户查询本租户已完成的逻辑表后台删除任务历史。

```shell
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY;

```

返回结果示例如下：

```sql
+---------------+-----------------+----------------+--------------+----------------------+------------------+---------------------+---------------------+--------------+--------------------+---------------+------------+
| DATABASE_NAME | COLLECTION_NAME | NAMESPACE_NAME | LTABLE_NAME  | OPERATION_TYPE       | OPERATION_STATUS | START_TIME          | FINISH_TIME         | ELAPSED_TIME | TOTAL_DELETED_ROWS | ORIGINAL_NAME | RET_CODE   |
+---------------+-----------------+----------------+--------------+----------------------+------------------+---------------------+---------------------+--------------+--------------------+---------------+------------+
| test          | kb              | app001         | chat_history | LTABLE_DELETE        | COMPLETED        | 2026-06-05 10:00:01 | 2026-06-05 10:03:15 |   194000000 |              45000 | chat_history  | OB_SUCCESS |
| test          | kb              | ns_images      |              | NAMESPACE_DELETE     | COMPLETED        | 2026-06-05 10:01:00 | 2026-06-05 10:04:30 |   210000000 |              80000 | ns_images     | OB_SUCCESS |
| test          | kb              | ns_hot_cache   |              | HOT_NAMESPACE_EXPIRE | FAILED           | 2026-06-05 09:00:00 | 2026-06-05 09:00:01 |     1000000 |                  0 | ns_hot_cache  | OB_ERROR   |
+---------------+-----------------+----------------+--------------+----------------------+------------------+---------------------+---------------------+--------------+--------------------+---------------+------------+

```

## 相关文档

- [CDB_OB_AGENT_DB_BACKGROUND_TASK_HISTORY](https://www.oceanbase.com/docs/common-oceanbase-database-ai-1000000006779940)
 - [DBA_OB_AGENT_DB_BACKGROUND_TASKS](https://www.oceanbase.com/docs/common-oceanbase-database-ai-1000000006780545)

 上一篇 下一篇 ![有帮助](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) 咨询热线