开发者社区 问答 正文

OceanBase数据库请问这报错是什么情况?

OceanBase数据库请问这报错是什么情况?2bfece4699a01ba4052aec2d361814ba.png

展开
收起
闲o月 2024-05-20 13:58:19 72 分享 版权
来自: OceanBase
1 条回答
写回答
取消 提交回答
  • "select a.zone, a.SVR_IP,a.SVR_PORT, b.status,cpu_capacity,cpu_assigned_max,cpu_capacity-cpu_assigned_max as cpu_free,round(memory_limit /1024/1024/1024 ,2) as memory_total_gb,round((memory_limit-mem_capacity) /1024/1024/1024 ,2) as system_memory_gb,round(mem_assigned /1024/1024/1024 ,2) as mem_assigned_gb,round((mem_capacity-mem_assigned) /1024/1024/1024 ,2) as memory_free_gb,round(log_disk_capacity /1024/1024/1024 ,2) as log_disk_capacity_gb,round(log_disk_assigned /1024/1024/1024 ,2) as log_disk_assigned_gb,round((log_disk_capacity-log_disk_assigned) /1024/1024/1024 ,2) as log_disk_free_gb,round((data_disk_capacity /1024/1024/1024 ),2) as data_disk_gb,round((data_disk_in_use /1024/1024/1024 ),2) as data_disk_used_gb,round((data_disk_capacity-data_disk_in_use) /1024/1024/1024 ,2) as data_disk_free_gb from gv$ob_servers a join oceanbase.DBA_OB_SERVERS b on a.zone=b.zone\G;

    看下 https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000749282 可以试下调整ob_sql_work_area_percentage参数 此回答整理自钉群:“[社区]技术答疑群OceanBase”"

    2024-05-21 13:02:33
    赞同 展开评论