各位老师，OB租户磁盘使用情况如何查询

[AntTech_WUVK1V]

怎么统计租户磁盘使用情况，ocp上有磁盘占有量和数据量，

查这个sql能统计租户磁盘使用情况吗：
SELECT a.tenant_id , b.tenant_name, ROUND(SUM(required_size)/ 1024 / 1024 / 1024, 2)
required_size_gb from gv$partition a, __all_tenant b where a.tenant_id = b.tenant_id and b
.tenant_name = ‘’

[AntTech_WUVK1V]

哪位老师能指点下

[王利博]

查看租户磁盘使用细节
select a.svr_ip,a.svr_port,a.tenant_id,b.tenant_name,
CAST(a.data_disk_in_use/1024/1024/1024 as DECIMAL(15,2)) data_disk_use_G,
CAST(a.log_disk_size/1024/1024/1024 as DECIMAL(15,2)) log_disk_size,
CAST(a.log_disk_in_use/1024/1024/1024 as DECIMAL(15,2)) log_disk_use_G
from __all_virtual_unit a,dba_ob_tenants b
where a.tenant_id=b.tenant_id;

[AntTech_WUVK1V]

@王利博

select a.svr_ip,a.svr_port,a.tenant_id,b.tenant_name,
CAST(a.data_disk_in_use/1024/1024/1024 as DECIMAL(15,2)) data_disk_use_G,
CAST(a.log_disk_size/1024/1024/1024 as DECIMAL(15,2)) log_disk_size,
CAST(a.log_disk_in_use/1024/1024/1024 as DECIMAL(15,2)) log_disk_use_G
from __all_virtual_unit a,dba_ob_tenants b
where a.tenant_id=b.tenant_id;

3.x的有吗

[和顺]

SELECT /*+ READ_CONSISTENCY(WEAK) /
tenant_id,
COUNT() AS replica_count,
SUM(data_size) AS data_size,
SUM(required_size) AS required_size
FROM __all_virtual_tenant_partition_meta_table
GROUP BY tenant_id;