测试环境，OceanBase_CE 4.1.0.1，远程登入observer，查看租户信息报错。
obclient [oceanbase]> select * from oceanbase.DBA_OB_TENANTS where tenant_id=1008;
ERROR 4013 (HY001): No memory or reach tenant memory limit
obclient [oceanbase]> 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
→ where tenant_type=‘USER’ and tenant_name=‘mq_t2’
→ order by b.tenant_name;
±------±------------±------------±------------±--------±--------±---------------±--------------±----------------±-----------------+
| zone | svr_ip | tenant_name | tenant_type | max_cpu | min_cpu | memory_size_gb | log_disk_size | log_disk_in_use | data_disk_in_use |
±------±------------±------------±------------±--------±--------±---------------±--------------±----------------±-----------------+
| zone2 | 10.18.8.194 | mq_t2 | USER | 1 | 1 | 0.50 | 9.00 | 1.25 | 0.06 |
| zone1 | 10.18.8.193 | mq_t2 | USER | 1 | 1 | 0.50 | 9.00 | 1.25 | 0.06 |
| zone4 | 10.18.8.216 | mq_t2 | USER | 1 | 1 | 0.50 | 9.00 | 0.85 | 0.02 |
| zone3 | 10.18.8.195 | mq_t2 | USER | 1 | 1 | 0.50 | 9.00 | 1.25 | 0.05 |
±------±------------±------------±------------±--------±--------±---------------±--------------±----------------±-----------------+
4 rows in set (0.026 sec)
obclient [oceanbase]> select t4.tenant_id,t4.tenant_name,t1.name resource_pool_name,t1.unit_count,
→ t2.name unit_config_name,t2.max_cpu,t2.min_cpu,
→ round(t2.memory_size/1024/1024/1024,2) mem_size_gb,
→ round(t2.log_disk_size/1024/1024/1024,2) log_disk_size_gb,t2.max_iops,
→ t2.min_iops,t3.unit_id,t3.zone,concat(t3.svr_ip,’:’,t3.svr_port) observer
→ from dba_ob_resource_pools t1
→ join dba_ob_unit_configs t2 on (t1.unit_config_id=t2.unit_config_id)
→ join dba_ob_units t3 on (t1.resource_pool_id=t3.resource_pool_id)
→ left join dba_ob_tenants t4 on (t1.tenant_id=t4.tenant_id)
→ where tenant_name=‘mq_t2’
→ order by t4.tenant_name,t3.zone;
±----------±------------±-------------------±-----------±-----------------±--------±--------±------------±-----------------±---------±---------±--------±------±-----------------+
| tenant_id | tenant_name | resource_pool_name | unit_count | unit_config_name | max_cpu | min_cpu | mem_size_gb | log_disk_size_gb | max_iops | min_iops | unit_id | zone | observer |
±----------±------------±-------------------±-----------±-----------------±--------±--------±------------±-----------------±---------±---------±--------±------±-----------------+
| 1008 | mq_t2 | mypool_01 | 1 | unit_1c1g | 1 | 1 | 1.00 | 10.00 | 10000 | 10000 | 1007 | zone1 | 10.18.8.193:2882 |
| 1008 | mq_t2 | mypool_01 | 1 | unit_1c1g | 1 | 1 | 1.00 | 10.00 | 10000 | 10000 | 1008 | zone2 | 10.18.8.194:2882 |
| 1008 | mq_t2 | mypool_01 | 1 | unit_1c1g | 1 | 1 | 1.00 | 10.00 | 10000 | 10000 | 1009 | zone3 | 10.18.8.195:2882 |
| 1008 | mq_t2 | mypool_01 | 1 | unit_1c1g | 1 | 1 | 1.00 | 10.00 | 10000 | 10000 | 1010 | zone4 | 10.18.8.216:2882 |
±----------±------------±-------------------±-----------±-----------------±--------±--------±------------±-----------------±---------±---------±--------±------±-----------------+
测试环境无业务数据，查看以上资源也还是充裕的，考虑扩大参数，ob_sql_work_area_percentage值，改成10。
obclient [oceanbase]> set global ob_sql_work_area_percentage = 10;
ERROR 4013 (HY001): No memory or reach tenant memory limit
但还是报错，但奇怪的是过一会就修改成功了，查询也没问题了，不知道有大佬能解答下这问题吗？
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接（右键跳转查看）：
