如何规划租户资源的容量？

查询租户的资源池、资源单元配置名称、资源单元配置
obclient>SELECT c.tenant_id, e.tenant_name, concat(c.name, ': ', d.name) `pool:conf`,
concat(c.unit_count, ' unit: ', d.min_cpu, 'C/', ROUND(d.min_memory/1024/1024/1024,0), "G") unit_info
FROM __all_resource_pool c, __all_unit_config d, __all_tenant e
WHERE c.unit_config_id=d.unit_config_id AND c.tenant_id=e.tenant_id AND c.tenant_id>1000
AND e.tenant_name='CIS2271'
ORDER BY c.tenant_id;

检查租户已使用的存储
obclient>SELECT e.tenant_name,a.svr_ip,round(sum(a.required_size)/1024/1024/1024,0)  required_GB,sum(row_count)  AS  rows  
FROM  __all_virtual_meta_table  a
INNER JOIN __all_virtual_table  b ON a.table_id=b.table_id 
INNER JOIN __all_virtual_database c ON b.database_id=c.database_id 
INNER JOIN __all_tenant e ON b.tenant_id=e.tenant_id 
WHERE e.tenant_name='CIS2271'
GROUP BY a.tenant_id,a.svr_ip
ORDER BY a.tenant_id,a.svr_ip;


检查租户的 Partition 总数
obclient>SELECT zone,svr_ip,tenant_name,count(1) cnt 
FROM __all_virtual_meta_table a , __all_tenant b
WHERE a.tenant_id=b.tenant_id and b.tenant_name ='CIS2271'
GROUP BY zone,svr_ip,tenant_name ORDER BY zone,svr_ip,tenant_name desc;


检查集群的所有资源

磁盘空间实时统计
obclient>SELECT /*+READ_CONSISTENCY(WEAK), QUERY_TIMEOUT(100000000)*/ \
  b.zone,a.svr_ip, \
  round(total_size/1024/1024/1024, 2) total_G, \
  round((total_size - free_size) /1024/1024/1024, 2) used_G, \
  round(free_size/1024/1024/1024, 2) free_G, \
  concat(round((total_size - free_size) / total_size * 100, 2), '%') used_percent \
FROM __all_virtual_disk_stat a, __all_server b
WHERE a.svr_ip = b.svr_ip  ORDER BY b.zone,svr_ip;

所有可用的 CPU 和 Memory 情况
obclient>SELECT b.zone,a.svr_ip, a.cpu_total, a.cpu_assigned, a.cpu_assigned_percent, a.mem_total/1024/1024/1024 AS mem_total, 
a.mem_assigned/1024/1024/1024 AS mem_assigned, (a.mem_total-a.mem_assigned)/1024/1024/1024 AS mem_free, a.mem_assigned_percent 
From __all_virtual_server_stat a,__all_server b WHERE a.svr_ip = b.svr_ip  ORDER BY zone,cpu_assigned_percent desc;

obclient>SELECT owner,segment_type,round(sum(bytes/power(1024,2))) size_MB 

FROM dba_segments 
GROUP BY owner,segment_type order by owner,segment_type;