OceanBase这个sql查看，资源不是通用的吗？

回答1：是的，这个SQL语句查询的是OceanBase集群中各节点的资源使用情况，包括CPU和内存等。不过需要注意的是，这个SQL语句可能会因为版本差异而产生变化，需要根据具体版本进行调整。

回答2：具体考试内容需要参考考试说明，但是掌握这个SQL语句对于了解OceanBase集群资源使用情况是很有帮助的。

回答1：3.x 和4.x版本修改了一些元数据表 。所以不能通用的 3.x select u.zone,u.svr_ip,u.svr_port, max(s.cpu_total), sum(u.max_cpu) as assigned_max_cpu, max(s.cpu_total)-sum(u.max_cpu) as free_cpu, round(max(s.mem_total/1024/1024/1024),2) as memory_total, round(sum(u.max_memory/1024/1024/1024),2) as assigned_max_memory, round(max(s.mem_total/1024/1024/1024),2)-round(sum(u.max_memory/1024/1024/1024),2) as free_memory from oceanbase.gv$unit u, oceanbase.__all_virtual_server_stat s where s.svr_ip=u.svr_ip and s.svr_port=u.svr_port group by u.svr_ip,u.svr_port order by zone;

4.x

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;

select a.zone,concat(a.svr_ip,':',a.svr_port) observer,a.CPU_CAPACITY cpu_total, (CPU_CAPACITY-cpu_assigned) cpu_free, round(a.memory_limit/1024/1024/1024 ) mem_total_gb, round((memory_limit-mem_assigned)/1024/1024/1024) mem_free_gb, round(a.LOG_DISK_CAPACITY/1024/1024/1024) logdisk_total, round((a.LOG_DISK_CAPACITY-a.LOG_DISK_ASSIGNED)/1024/1024/1024) logdisk_free , round(a.DATA_DISK_CAPACITY/1024/1024/1024) data_total ,round((DATA_DISK_CAPACITY-a.DATA_DISK_IN_USE)/1024/1024/1024) data_free ,b.status,usec_to_time(b.start_service_time) start_service_time, usec_to_time(b.stop_time) stop_time ,b.build_version from GV$OB_SERVERS a join __all_server b on (a.svr_ip=b.svr_ip and a.svr_port=b.svr_port) order by a.zone, a.svr_ip; 回答2：记住资源相关的表即可。考试要求没这么难，此回答整理自钉群“[社区]技术答疑群OceanBase”