SELECT tenant_id, hold ,free
FROM oceanbase.gv$ob_tenant_memory
WHERE svr_ip = ‘10.10.1.71’
AND svr_port=2882
AND tenant_id=1
GROUP BY tenant_id;
问题:
hold + free 并不等于 memory_size 啊 ? 为什么 ?
SELECT tenant_id, hold ,free
FROM oceanbase.gv$ob_tenant_memory
WHERE svr_ip = ‘10.10.1.71’
AND svr_port=2882
AND tenant_id=1
GROUP BY tenant_id;
问题:
hold + free 并不等于 memory_size 啊 ? 为什么 ?
你可以用这个语句 来查看
select a.zone,a.svr_ip,b.tenant_name,b.tenant_type, a.max_cpu, a.min_cpu,
round(a.memory_size/1024/1024/1024,2) memory_size_gb,
round(a.log_disk_size/1024/1024/1024,2) log_disk_size,
round(a.log_disk_in_use/1024/1024/1024,2) log_disk_in_use,
round(a.data_disk_in_use/1024/1024/1024,2) data_disk_in_use
from oceanbase.gv$ob_units a join oceanbase.dba_ob_tenants b on a.tenant_id=b.tenant_id order by b.tenant_name;