--- title: "查看资源的分配情况 - OceanBase 数据库 V4.1.0 | OceanBase 文档中心" description: 查看资源的分配情况 OceanBase 数据库支持通过视图查看租户的资源分配情况。 操作步骤 使用 root 用户登录集群的 sys 租户。 进入 oceanbase 数据库。 obclient>USE oceanbase; 执行以下命令，查看集群内各 Server 的资源分配情况。 obclient> SELECT… --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.1.0 # 查看资源的分配情况 更新时间：2023-08-01 11:45:47 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.1.0/zh-CN/700.reference/200.administrator-guide/200.basic-database-management/300.manage-resources/600.view-resource-allocation.md) OceanBase 数据库支持通过视图查看租户的资源分配情况。 ## 操作步骤 1. 使用 `root` 用户登录集群的 `sys` 租户。 2. 进入 `oceanbase` 数据库。 ```sql obclient>USE oceanbase; ``` 3. 执行以下命令，查看集群内各 Server 的资源分配情况。 ```sql obclient> SELECT * FROM oceanbase.GV$OB_SERVERS\G *************************** 1. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 ZONE: zone1 SQL_PORT: 2881 CPU_CAPACITY: 62 CPU_CAPACITY_MAX: 62 CPU_ASSIGNED: 4.5 CPU_ASSIGNED_MAX: 4.5 MEM_CAPACITY: 75161927680 MEM_ASSIGNED: 30064771072 LOG_DISK_CAPACITY: 179583320064 LOG_DISK_ASSIGNED: 55834574848 LOG_DISK_IN_USE: 9395240960 DATA_DISK_CAPACITY: 107374182400 DATA_DISK_IN_USE: 4724883456 DATA_DISK_HEALTH_STATUS: NORMAL DATA_DISK_ABNORMAL_TIME: NULL *************************** 2. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 ZONE: zone2 SQL_PORT: 2881 CPU_CAPACITY: 62 CPU_CAPACITY_MAX: 62 CPU_ASSIGNED: 4.5 CPU_ASSIGNED_MAX: 4.5 MEM_CAPACITY: 75161927680 MEM_ASSIGNED: 30064771072 LOG_DISK_CAPACITY: 179583320064 LOG_DISK_ASSIGNED: 55834574848 LOG_DISK_IN_USE: 9395240960 DATA_DISK_CAPACITY: 107374182400 DATA_DISK_IN_USE: 4724883456 DATA_DISK_HEALTH_STATUS: NORMAL DATA_DISK_ABNORMAL_TIME: NULL *************************** 3. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 ZONE: zone3 SQL_PORT: 2881 CPU_CAPACITY: 62 CPU_CAPACITY_MAX: 62 CPU_ASSIGNED: 4.5 CPU_ASSIGNED_MAX: 4.5 MEM_CAPACITY: 75161927680 M EM_ASSIGNED: 30064771072 LOG_DISK_CAPACITY: 179583320064 LOG_DISK_ASSIGNED: 55834574848 LOG_DISK_IN_USE: 9395240960 DATA_DISK_CAPACITY: 107374182400 DATA_DISK_IN_USE: 4724883456 DATA_DISK_HEALTH_STATUS: NORMAL DATA_DISK_ABNORMAL_TIME: NULL 3 row in set ``` 更多视图 `oceanbase.GV$OB_SERVERS` 的说明信息请参见 [GV$OB_SERVERS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-10000000001699210)。 4. 执行以下命令，查看集群内所有租户的资源分配情况。 ```sql obclient> SELECT * FROM oceanbase.GV$OB_UNITS\G *************************** 1. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 UNIT_ID: 1 T ENANT_ID: 1 ZONE: zone1 MAX_CPU: 2.5 MIN_CPU: 2.5 MEMORY_SIZE: 17179869184 MAX_IOPS: 25000 MIN_IOPS: 25000 IOPS_WEIGHT: 2 LOG_DISK_SIZE: 17179869184 LOG_DISK_IN_USE: 191441460 DATA_DISK_IN_USE: 406847488 STATUS: NORMAL CREATE_TIME: 2022-07-19 11:04:39.226231 *************************** 2. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 UNIT_ID: 1001 TENANT_ID: 1001 ZONE: zone1 MAX_CPU: NULL MIN_CPU: NULL MEMORY_SIZE: 644245094 MAX_IOPS: NULL MIN_IOPS: NULL IOPS_WEIGHT: NULL LOG_DISK_SIZE: 1932735283 LOG_DISK_IN_USE: 155042605 DATA_DISK_IN_USE: 211812352 STATUS: NORMAL CREATE_TIME: 2022-07-19 13:48:36.308843 *************************** 3. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 UNIT_ID: 1001 TENANT_ID: 1002 ZONE: zone1 MAX_CPU: 1 MIN_CPU: 1 MEMORY_SIZE: 5798205850 MAX_IOPS: 10000 MIN_IOPS: 10000 IOPS_WEIGHT: 1 LOG_DISK_SIZE: 17394617549 LOG_DISK_IN_USE: 154632504 DATA_DISK_IN_USE: 121634816 STATUS: NORMAL C REATE_TIME: 2022-07-19 13:48:36.308843 *************************** 4. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 UNIT_ID: 1002 TENANT_ID: 1005 ZONE: zone1 MAX_CPU: NULL MIN_CPU: NULL MEMORY_SIZE: 644245094 MAX_IOPS: NULL MIN_IOPS: NULL I OPS_WEIGHT: NULL LOG_DISK_SIZE: 1932735283 LOG_DISK_IN_USE: 152132563 DATA_DISK_IN_USE: 211812352 STATUS: NORMAL CREATE_TIME: 2022-07-19 13:51:56.627867 *************************** 5. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 UNIT_ID: 1002 TENANT_ID: 1006 ZONE: zone1 MAX_CPU: 1 MIN_CPU: 1 MEMORY_SIZE: 5798205850 MAX_IOPS: 10000 MIN_IOPS: 10000 IOPS_WEIGHT: 1 LOG_DISK_SIZE: 17394617549 LOG_DISK_IN_USE: 158023991 DATA_DISK_IN_USE: 134217728 STATUS: NORMAL CREATE_TIME: 2022-07-19 13:51:56.627867 5 rows in set ``` 更多视图 `oceanbase.GV$OB_UNITS` 的说明信息请参见 [GV$OB_UNITS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-10000000001699214)。 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线