---
title: "数据盘 - 云平台 OCP V4.3.6 | OceanBase 文档中心"
description: 数据盘 本节为您介绍 OceanBase 租户的监控指标 数据盘 。您可指定统计范围，查询租户在单个 Zone 或 OBServer 节点的 数据盘 数据。 data_disk_size 指标介绍 统计范围内，租户数据盘数据量。 指标参数说明 指标项 指标名称 单位 data_disk_size ob_tenant_…
---
切换语言

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

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*lJTmRZ61jSUAAAAAAAAAAAAADiGDAQ/original) 云平台 OCPV 4.3.6

# 数据盘

更新时间：2026-04-02 18:05:50

[编辑](https://github.com/oceanbase/ocp-doc/edit/V4.3.6/zh-CN/1900.reference-guide/300.monitoring-indicator-reference/400.oceanbase-database-tenant/300.storage-and-cache/1000.data-disk.md)  

本节为您介绍 OceanBase 租户的监控指标 **数据盘** 。您可指定统计范围，查询租户在单个 Zone 或 OBServer 节点的 **数据盘** 数据。

## data_disk_size

### 指标介绍

统计范围内，租户数据盘数据量。

### 指标参数说明

| **指标项** | **指标名称** | **单位** |
| --- | --- | --- |
| data_disk_size | ob_tenant_data_size | Byte |

### 计算表达式

sum(ob_tenant_server_data_size{@LABELS}) by (@GBLABELS)

### 采集 SQL

- OceanBase V4.0 以下版本：

  ```sql
  SELECT /*+ READ_CONSISTENCY(WEAK) QUERY_TIMEOUT(50000000) */ tenant_id, svr_ip, svr_port, sum(data_size) as data_size, sum(required_size) as required_size, sum(row_count) row_count from (SELECT tenant_id, svr_ip, svr_port, table_id, partition_id, data_size, required_size, row_count FROM __all_virtual_meta_table union SELECT tenant_id, svr_ip, svr_port, table_id, partition_id, data_size, required_size, row_count FROM __all_root_table) group by tenant_id, svr_ip, svr_port

  ```
 - OceanBase V4.0 及以上版本：

  ```sql
  SELECT /*+ READ_CONSISTENCY(WEAK) QUERY_TIMEOUT(50000000) */ a.tenant_id,a.svr_ip,a.svr_port,sum(data_size) as data_size, sum(required_size) as required_size FROM CDB_OB_TABLE_LOCATIONS a LEFT JOIN (SELECT tenant_id,tablet_id,svr_ip,svr_port,data_size,required_size FROM __all_virtual_tablet_meta_table) b ON a.TENANT_ID = b.tenant_id AND a.tablet_id = b.tablet_id AND a.SVR_IP = b.SVR_IP AND a.SVR_PORT = b.SVR_PORT LEFT JOIN __all_virtual_table c ON a.TENANT_ID = c.TENANT_ID AND a.table_id = c.table_id group by a.tenant_id, a.svr_ip,a.svr_port

  ```

## data_disk_used

### 指标介绍

统计范围内，租户数据盘占用量。

### 指标参数说明

| **指标项** | **指标名称** | **单位** |
| --- | --- | --- |
| data_disk_used | ob_tenant_disk_used | Byte |

### 计算表达式

sum(ob_tenant_server_required_size{@LABELS}) by (@GBLABELS)

  ```

## data_index_size

### 指标介绍

统计范围内，租户数据盘索引大小。

### 指标参数说明

| **指标项** | **指标名称** | **单位** |
| --- | --- | --- |
| data_index_size | ob_tenant_data_index_size | Byte |

### 计算表达式

sum(ob_tenant_server_data_index_data_size{@LABELS}) by (@GBLABELS)

  ```sql
  SELECT /*+ READ_CONSISTENCY(WEAK) QUERY_TIMEOUT(50000000) */ a.tenant_id,a.svr_ip,a.svr_port,SUM(data_size) AS data_size FROM cdb_ob_table_locations a JOIN (SELECT tenant_id,tablet_id,svr_ip,svr_port,data_size,required_size FROM __all_virtual_tablet_meta_table) b ON a.tenant_id = b.tenant_id AND a.tablet_id = b.tablet_id AND a.svr_ip = b.svr_ip AND a.svr_port = b.svr_port JOIN __all_virtual_table c ON a.tenant_id = c.tenant_id AND c.table_type = 5 AND a.table_id = c.table_id GROUP BY a.tenant_id,a.svr_ip,a.svr_port

  ```sql
  select /*+ READ_CONSISTENCY(WEAK) QUERY_TIMEOUT(50000000) */ a.tenant_id, b.svr_ip, b.svr_port, sum(size) as data_size from __all_virtual_table_mgr b left join __all_virtual_table a on a.tenant_id = b.tenant_id and a.table_id = b.index_id where a.table_type = 5 group by 1, 2, 3

  ```

## data_disk_used_percentage

### 指标介绍

统计范围内，租户数据盘使用百分比。

### 指标参数说明

| **指标项** | **指标名称** | **单位** |
| --- | --- | --- |
| data_disk_used_percentage | ob_tenant_disk_used_percentage | % |

### 计算表达式

100 * (sum(ob_tenant_server_required_size{@LABELS}) by (@GBLABELS) / sum(ob_tenant_disk_total_size{@LABELS}) by (@GBLABELS))

### 采集 SQL

- **ob_tenant_server_required_size**

      ```
 - **ob_tenant_disk_total_size**

      ```sql
      SELECT t2.tenant_id, t2.tenant_name, t1.total_size FROM __all_virtual_disk_stat t1 JOIN (SELECT tenant_id, tenant_name, svr_ip, svr_port FROM `v$unit`) t2 ON t1.svr_ip=t2.svr_ip AND t1.svr_port=t2.svr_port WHERE t1.svr_ip = ? AND t1.svr_port = ?

      ```sql
      select /* MONITOR_AGENT */ T4.tenant_id as tenant_id, t4.tenant_name, t1.data_disk_capacity as total_size from V$OB_SERVERS t1 JOIN (SELECT t2.tenant_id, t3.tenant_name, t2.svr_ip, t2.svr_port FROM v$ob_units t2 left join DBA_OB_TENANTS t3 on t2.tenant_id=t3.tenant_id WHERE T3.tenant_type<>'META') t4 ON t1.svr_ip=t4.svr_ip AND t1.svr_port=t4.svr_port WHERE t1.svr_ip = ? AND t4.svr_port = ?

      ```

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