obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 1768.00000000 | | 1 | 127.0.0.1 | SqlPhyPlan | 165.34539795 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 5 rows in set (0.005 sec) obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 1770.00000000 | | 1 | 127.0.0.1 | SqlPhyPlan | 165.34539795 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 5 rows in set (0.003 sec)