零基础OceanBase数据库入门(2）：查看集群基本信息

俊才

发布于 2026-03-31 12:44:33

1160

作为一款原生分布式数据库，OceanBase的集群是所有操作和运维的核心载体。不管是开发调试还是日常运维，先掌握「如何查看集群基本信息」，能让我们快速了解集群的运行状态、资源配置、部署模式，为后续的租户管理、性能调优打下基础。今天就结合OceanBase官方demo来学习。

零基础OceanBase数据库入门：搭建你的第一个OceanBase数据库

一、 demo本机部署

因为官方查看集群基本信息的demo页面需在电脑端打开，才能保证完整的操作体验！因此我自己部署了一个demo。

1. 下载

从官方下载地址下载最新版一键安装包即可，地址如下：

https://www.oceanbase.com/softwarecenter

2. 部署

其他部署步骤也可以参考

零基础OceanBase数据库入门：搭建你的第一个OceanBase数据库

当前我用的这个版本用 sh bin/install.sh即可安装

运行完毕如下：

执行命令让环境变量生效

 source ~/.oceanbase-all-in-one/bin/env.sh

3. 创建demo

通过obd方式创建demo

obd demo

完毕后如下：

验证部署结果

这样就部署完毕了。

二、查看OceanBase集群基本信息

下面我们就用页面obshell方式及命令行方式对照来学习OceanBase集群的基本信息查看的方法。

1. 连接集群

使用 root 用户登录集群的 sys 租户。

命令行方式：

obclient -h127.0.0.1 -P2881 -uroot@sys -p'1K4TjgkntnXm3r2nAGLE' -Doceanbase -A

obshell方式：

之前部署好的demo里有对应的信息：

浏览器中输入对于的密码即可

2. 查看集群默认创建的Zone信息及节点信息

命令行

查看集群的Zone信息，可以查询oceanbase.DBA_OB_ZONES视图

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_ZONES;
+-------+----------------------------+----------------------------+--------+-------------+---------------+-----------+
| ZONE  | CREATE_TIME                | MODIFY_TIME                | STATUS | IDC         | REGION        | TYPE      |
+-------+----------------------------+----------------------------+--------+-------------+---------------+-----------+
| zone1 | 2026-03-30 14:29:28.386408 | 2026-03-30 14:29:50.334032 | ACTIVE | default_idc | deault_region | ReadWrite |
+-------+----------------------------+----------------------------+--------+-------------+---------------+-----------+
1 row in set (0.136 sec)

查看完Zone再来查看下默认创建的节点信息，可以通过查询oceanbase.DBA_OB_SERVERS视图，获取集群中的节点信息。

obshell方式：

页面上更直观，可能看到下钻的更多细节信息

3. 查看默认的资源信息

3.1 查看默认的资源池信息

可用使用DBA_OB_RESOURCE_POOLS视图，查看资源池信息。

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_RESOURCE_POOLS;
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-----------+--------------+
| RESOURCE_POOL_ID | NAME     | TENANT_ID | CREATE_TIME                | MODIFY_TIME                | UNIT_COUNT | UNIT_CONFIG_ID | ZONE_LIST | REPLICA_TYPE |
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-----------+--------------+
|                1 | sys_pool |         1 | 2026-03-30 14:29:27.783321 | 2026-03-30 14:29:27.809908 |          1 |              1 | zone1     | FULL         |
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-----------+--------------+
1 row in set (0.005 sec)

从查询结果看，默认的资源池名称是sys_pool，资源池的ID（RESOURCE_POOL_ID）是1，归属于的租户ID（TENANT_ID）是1、使用的资源规格ID（UNIT_CONFIG_ID）是1，资源池的Unit个数（UNIT_COUNT）是1，使用的Zone列表（ZONE_LIST）是zone1。

3.2 查看默认的资源规格信息

通过DBA_OB_UNIT_CONFIGS视图，可以查看资源规格信息。

obclient(root@sys)[oceanbase]> SELECT * FROM DBA_OB_UNIT_CONFIGS;
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+----------------+---------------------+---------------------+-------------+---------------------+----------------------+
| UNIT_CONFIG_ID | NAME            | CREATE_TIME                | MODIFY_TIME                | MAX_CPU | MIN_CPU | MEMORY_SIZE | LOG_DISK_SIZE | DATA_DISK_SIZE | MAX_IOPS            | MIN_IOPS            | IOPS_WEIGHT | MAX_NET_BANDWIDTH   | NET_BANDWIDTH_WEIGHT |
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+----------------+---------------------+---------------------+-------------+---------------------+----------------------+
|              1| sys_unit_config |2026-03-3014:29:27.769918|2026-03-3014:29:27.769918|       2|       2|1073741824|    2147483648|           NULL|9223372036854775807|9223372036854775807|           2|9223372036854775807|                    2 |
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+----------------+---------------------+---------------------+-------------+---------------------+----------------------+
1 row in set (0.015 sec)

从查询结果看，默认创建的资源规格（UNIT_CONFIG_ID）名称是sys_unit_config，资源规格ID（UNIT_CONFIG_ID）是1，CPU规格上限（MAX_CPU）是2C，内存规格（MEMORY_SIZE）是1073741824/1024/1024/1024=1G，日志盘空间（LOG_DISK_SIZE）是2147483648/1024/1024/1024=2G。

通过GV$OB_UNITS视图，也可以查看节点的Unit信息。

obclient(root@sys)[oceanbase]> SELECT * FROM GV$OB_UNITS;

结果显示如下

3.3 查看资源分配信息

通过 GV$OB_SERVERS 视图，可以查看 OBServer 的信息。

obclient(root@sys)[oceanbase]> SELECT * FROM GV$OB_SERVERS;
+-----------+----------+-------+----------+--------------+------------------+--------------+------------------+--------------+--------------+-------------------+-------------------+-----------------+--------------------+--------------------+------------------+-------------------------+--------------+---------------------+-------------------------+-----------------------+----------------------------------+-----------------------------+
| SVR_IP    | SVR_PORT | ZONE  | SQL_PORT | CPU_CAPACITY | CPU_CAPACITY_MAX | CPU_ASSIGNED | CPU_ASSIGNED_MAX | MEM_CAPACITY | MEM_ASSIGNED | LOG_DISK_CAPACITY | LOG_DISK_ASSIGNED | LOG_DISK_IN_USE | DATA_DISK_CAPACITY | DATA_DISK_ASSIGNED | DATA_DISK_IN_USE | DATA_DISK_HEALTH_STATUS | MEMORY_LIMIT | DATA_DISK_ALLOCATED | DATA_DISK_ABNORMAL_TIME | SSL_CERT_EXPIRED_TIME | SS_DATA_DISK_OPERATION_SUGGESTED | SS_DATA_DISK_SIZE_SUGGESTED |
+-----------+----------+-------+----------+--------------+------------------+--------------+------------------+--------------+--------------+-------------------+-------------------+-----------------+--------------------+--------------------+------------------+-------------------------+--------------+---------------------+-------------------------+-----------------------+----------------------------------+-----------------------------+
| 127.0.0.1|     2882| zone1 |     2881|            8|                8|            2|                2|   5368709120|   1073741824|       15032385536|        2147483648|       201326592|         8589934592|               NULL|         98566144| NORMAL                  |   6442450944|          2147483648|NULL                    |NULL                  |NULL                             |                        NULL |
+-----------+----------+-------+----------+--------------+------------------+--------------+------------------+--------------+--------------+-------------------+-------------------+-----------------+--------------------+--------------------+------------------+-------------------------+-----------

从查询结果看，节点IP（SVR_IP）是127.0.0.1，服务器端口号（SVR_PORT）是2882，对应的zone名称（zone）是zone1，SQL端口（SQL_PORT）是2881，observer进程可用的CPU数量（CPU_CAPACITY）是8C，observer进程可用的内存（MEM_CAPACITY），已分配的内存（MEM_ASSIGNED），日志盘总空间（LOG_DISK_CAPACITY），已分配日志盘空间（LOG_DISK_ASSIGNED），日志盘已使用（LOG_DISK_IN_USE），数据盘空间（DATA_DISK_CAPACITY），数据盘已使用（DATA_DISK_IN_USE）。

3.4 查询 Unit 列表

可以通过如下SQL，查询当前集群的unit对应的租户、所在的主机等更详细的信息

obclient(root@sys)[oceanbase]> SELECT
    ->   /*+ QUERY_TIMEOUT(5000000) */
    ->   t1.UNIT_ID,
    ->   t1.RESOURCE_POOL_ID,
    ->   t1.ZONE,
    ->   t1.SVR_IP,
    ->   t1.SVR_PORT,
    ->   t1.STATUS,
    ->   t2.REPLICA_TYPE,
    ->   t2.TENANT_ID,
    ->   t3.TENANT_NAME,
    ->   t2.NAME AS RESOURCE_POOL_NAME,
    ->   t1.MIGRATE_FROM_SVR_IP,
    ->   t1.MIGRATE_FROM_SVR_PORT,
    ->   t1.MANUAL_MIGRATE
    -> FROM
    ->   oceanbase.DBA_OB_UNITS AS t1
    ->   JOIN oceanbase.DBA_OB_RESOURCE_POOLS AS t2 ON t1.RESOURCE_POOL_ID = t2.RESOURCE_POOL_ID
    ->   JOIN oceanbase.DBA_OB_TENANTS t3 ON t2.TENANT_ID = t3.TENANT_ID;
+---------+------------------+-------+-----------+----------+--------+--------------+-----------+-------------+--------------------+---------------------+-----------------------+----------------+
| UNIT_ID | RESOURCE_POOL_ID | ZONE  | SVR_IP    | SVR_PORT | STATUS | REPLICA_TYPE | TENANT_ID | TENANT_NAME | RESOURCE_POOL_NAME | MIGRATE_FROM_SVR_IP | MIGRATE_FROM_SVR_PORT | MANUAL_MIGRATE |
+---------+------------------+-------+-----------+----------+--------+--------------+-----------+-------------+--------------------+---------------------+-----------------------+----------------+
|       1 |                1 | zone1 | 127.0.0.1 |     2882 | ACTIVE | FULL         |         1 | sys         | sys_pool           | NULL                |                  NULL | NULL           |
+---------+------------------+-------+-----------+----------+--------+--------------+-----------+-------------+--------------------+---------------------+-----------------------+----------------+
1 row in set (0.077 sec)

3.5 页面方式查看

obshell页面上可以直观看到资源使用情况信息：

4. 查看租户信息

通过DBA_OB_TENANTS视图，可以查看租户信息。

obclient(root@sys)[oceanbase]> SELECT * FROM DBA_OB_TENANTS;
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------+-------------------+--------------------+--------+---------------+--------+-------------+-------------------+------------------+----------+----------------+--------------+--------------------+--------------+----------------------------+----------+------------+-----------+-------------------+-------------------+---------------+
| TENANT_ID | TENANT_NAME | TENANT_TYPE | CREATE_TIME                | MODIFY_TIME                | PRIMARY_ZONE | LOCALITY      | PREVIOUS_LOCALITY | COMPATIBILITY_MODE | STATUS | IN_RECYCLEBIN | LOCKED | TENANT_ROLE | SWITCHOVER_STATUS | SWITCHOVER_EPOCH | SYNC_SCN | REPLAYABLE_SCN | READABLE_SCN | RECOVERY_UNTIL_SCN | LOG_MODE     | ARBITRATION_SERVICE_STATUS | UNIT_NUM | COMPATIBLE | MAX_LS_ID | RESTORE_DATA_MODE | FLASHBACK_LOG_SCN | COMMENT       |
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------+-------------------+--------------------+--------+---------------+--------+-------------+-------------------+------------------+----------+----------------+--------------+--------------------+--------------+----------------------------+----------+------------+-----------+-------------------+-------------------+---------------+
|         1 | sys         | SYS         | 2026-03-30 14:29:27.859965 | 2026-03-30 14:29:27.859965 | RANDOM       | FULL{1}@zone1 | NULL              | MYSQL              | NORMAL | NO            | NO     | PRIMARY     | NORMAL            |                0 |     NULL |           NULL |         NULL |               NULL | NOARCHIVELOG | DISABLED                   |        1 | 4.5.0.0    |         1 | NORMAL            |              NULL | system tenant |
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------+-------------------+--------------------+--------+---------------+--------+-------------+-------------------+------------------+----------+----------------+--------------+--------------------+--------------+----------------------------+----------+------------+-----------+-------------------+-------------------+---------------+
1 row in set (0.123 sec)

从查询结果看，默认创建的租户名称（TENANT_NAME）是sys，租户ID（TENANT_ID）是1，租户类型（TENANT_TYPE）是SYS租户，租户的PRIMARY_ZONE（PRIMARY_ZONE）是RANDOM，租户副本分布（LOCALITY）在zone1，兼容模式（COMPATIBILITY_MODE）是MySQL，即默认创建的SYS租户为MySQL模式。

查看租户的资源单元部署位置

通过以下语句，查看当前已创建租户资源单元所在设备IP信息。

obclient(root@sys)[oceanbase]> SELECT a.TENANT_NAME,a.TENANT_ID,b.SVR_IP FROM DBA_OB_TENANTS a,GV$OB_UNITS b WHERE a.TENANT_ID=b.TENANT_ID;
+-------------+-----------+-----------+
| TENANT_NAME | TENANT_ID | SVR_IP    |
+-------------+-----------+-----------+
| sys         |         1 | 127.0.0.1 |
+-------------+-----------+-----------+
1 row in set (0.031 sec)

从查询结果可以看出，SYS租户对应的ID为1，资源所在节点的IP为127.0.0.1。

页面方式查看

5. 查询数据库列表

命令行：

可以通过如下SQL，查询已存在的数据库的相关信息。

obclient(root@sys)[oceanbase]> SELECT
    ->   o.CREATED AS GMT_CREATE,
    ->   o.OBJECT_ID AS DATABASE_ID,
    ->   d.DATABASE_NAME,
    ->   c.ID AS COLLATION_TYPE,
    ->   NULL AS PRIMARY_ZONE,
    ->   0 AS READ_ONLY
    -> FROM
    ->   oceanbase.DBA_OB_DATABASES d
    ->   JOIN oceanbase.DBA_OBJECTS o
    ->   JOIN information_schema.collations c ON d.DATABASE_NAME = o.OBJECT_NAME
    ->   AND d.COLLATION = c.COLLATION_NAME
    -> WHERE
    ->   o.OBJECT_TYPE = 'DATABASE';
+---------------------+-------------+--------------------+----------------+--------------+-----------+
| GMT_CREATE          | DATABASE_ID | DATABASE_NAME      | COLLATION_TYPE | PRIMARY_ZONE | READ_ONLY |
+---------------------+-------------+--------------------+----------------+--------------+-----------+
| 2026-03-30 14:29:28 |      201001 | oceanbase          |             45 |         NULL |         0 |
| 2026-03-30 14:29:28 |      201002 | information_schema |             45 |         NULL |         0 |
| 2026-03-30 14:29:28 |      201003 | mysql              |             45 |         NULL |         0 |
| 2026-03-30 14:29:28 |      201004 | __recyclebin       |             45 |         NULL |         0 |
| 2026-03-30 14:29:28 |      201005 | __public           |             45 |         NULL |         0 |
| 2026-03-30 14:29:28 |      201006 | SYS                |             45 |         NULL |         0 |
| 2026-03-30 14:29:28 |      201007 | LBACSYS            |             45 |         NULL |         0 |
| 2026-03-30 14:29:28 |      201008 | ORAAUDITOR         |             45 |         NULL |         0 |
| 2026-03-30 14:29:28 |      500001 | test               |             45 |         NULL |         0 |
| 2026-03-30 14:29:44 |      500002 | sys_external_tbs   |             45 |         NULL |         0 |
| 2026-03-30 14:30:27 |      500006 | ocs                |             45 |         NULL |         0 |
+---------------------+-------------+--------------------+----------------+--------------+-----------+
11 rows in set (0.362 sec)

obclient(root@sys)[oceanbase]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| LBACSYS            |
| mysql              |
| oceanbase          |
| ocs                |
| ORAAUDITOR         |
| SYS                |
| sys_external_tbs   |
| test               |
+--------------------+
9 rows in set (0.003 sec)

页面方式查看：

6. 查看集群配置项

通过GV$OB_PARAMETERS视图，查询集群的配置项。

obclient(root@sys)[oceanbase]> SELECT * FROM GV$OB_PARAMETERS WHERE NAME LIKE '%syslog_level%'\G
*************************** 1. row ***************************
       SVR_IP: 127.0.0.1
     SVR_PORT: 2882
         ZONE: zone1
        SCOPE: CLUSTER
    TENANT_ID: NULL
         NAME: syslog_level
    DATA_TYPE: STRING
        VALUE: WDIAG
         INFO: specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels.
      SECTION: OBSERVER
   EDIT_LEVEL: DYNAMIC_EFFECTIVE
DEFAULT_VALUE: WDIAG
    ISDEFAULT: YES
1 row in set (0.025 sec)

页面查看结果如下：

7. 其他内容

页面上可以更直观的查看性能、配置、参数等信息：

三、学习小结

查看OceanBase集群基本信息，是入门的基础必学知识点新手用图形化界面，运维操作时可以考虑更精细化的用命令行。掌握这两种方法，就能快速了解集群的基本情况，为后续的租户创建、资源调整、性能调优做好准备。相信OceanBase的入门学习并不难，只要循序渐进，从基础的集群、租户开始，慢慢就能解锁更多高级功能～

本文参与腾讯云自媒体同步曝光计划，分享自微信公众号。

原始发表：2026-03-30，如有侵权请联系 cloudcommunity@tencent.com 删除

数据库