查看 OceanBase 集群基本信息
现有集群中仅包含一个 Zone 和一台主机；对于租户，创建了包含一个资源池 sys_pool 和一个资源规格 sys_unit_config 的MySQL 模式 SYS 租户。
连接集群
使用 root 用户登录集群的 sys 租户
obclient -h192.168.63.201 -P2881 -uroot@sys -p'ggj0F8Yt0MzZ3mnGy8r8' -Doceanbase -A
查看集群默认创建的 Zone 信息
查看集群的 Zone 信息，可以查询 oceanbase.DBA_OB_ZONES 视图。
SELECT * FROM oceanbase.DBA_OB_ZONES;
从查询结果可以看到，使用 all_in_one 包创建单机版 OceanBase 集群后，在本机上默认创建一个 Zone，该 Zone 为读写类型的可用状态，所在地为 deault_region，机房为 default_idc。
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_ZONES;
+-------+----------------------------+----------------------------+--------+-------------+---------------+-----------+
| ZONE | CREATE_TIME | MODIFY_TIME | STATUS | IDC | REGION | TYPE |
+-------+----------------------------+----------------------------+--------+-------------+---------------+-----------+
| zone1 | 2025-08-11 12:07:41.994339 | 2025-08-11 12:08:03.147973 | ACTIVE | default_idc | deault_region | ReadWrite |
+-------+----------------------------+----------------------------+--------+-------------+---------------+-----------+
1 row in set (0.021 sec)
查看默认的节点
查看完 Zone 再来查看下默认创建的节点信息，可以通过查询 oceanbase.DBA_OB_SERVERS 视图，获取集群中的节点信息。
SELECT * FROM oceanbase.DBA_OB_SERVERS;
从查询结果看，默认创建一个本地的节点，IP 为 127.0.0.1，默认的节点端口号为 2881，RPC 端口号为 2882，节点位于之前查到的 zone1 上，该节点是集群的 RS，是可用状态。
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_SERVERS;
+-----------+----------+------+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+-------------------+
| SVR_IP | SVR_PORT | ID | ZONE | SQL_PORT | WITH_ROOTSERVER | STATUS | START_SERVICE_TIME | STOP_TIME | BLOCK_MIGRATE_IN_TIME | CREATE_TIME | MODIFY_TIME | BUILD_VERSION | LAST_OFFLINE_TIME |
+-----------+----------+------+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+-------------------+
| 127.0.0.1 | 2882 | 1 | zone1 | 2881 | YES | ACTIVE | 2025-09-15 11:11:49.854509 | NULL | NULL | 2025-08-11 12:07:42.621634 | 2025-09-15 11:11:51.324817 | 4.2.5.4_104040052025071121-969b0573b5acaa8702a55910412894a7a33b7382(Jul 11 2025 21:46:10) | NULL |
+-----------+----------+------+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+-------------------+
1 row in set (0.003 sec)
查看默认的资源信息
查看默认的资源池信息
可用使用 DBA_OB_RESOURCE_POOLS 视图，查看资源池信息。
SELECT * FROM oceanbase.DBA_OB_RESOURCE_POOLS;
从查询结果看，默认的资源池（RESOURCE_POOL_ID）名称是 sys_pool ，资源池的 ID（RESOURCE_POOL_ID）是 1，归属于的租户 ID（TENANT_ID）是 1、使用的资源规格 ID（UNIT_CONFIG_ID）是 1，资源池的 Unit 个数（UNIT_COUNT）是 1，使用的 Zone 列表（ZONE_LIST）是 zone1。
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 | 2025-08-11 12:07:41.724685 | 2025-08-11 12:07:41.734644 | 1 | 1 | zone1 | FULL |
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-----------+--------------+
1 row in set (0.003 sec)
查看默认的资源规格信息
通过 DBA_OB_UNIT_CONFIGS 视图
通过 DBA_OB_UNIT_CONFIGS 视图，可以查看资源规格信息。
SELECT * FROM DBA_OB_UNIT_CONFIGS;
从查询结果看，默认创建的资源规格（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。
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 | MAX_IOPS | MIN_IOPS | IOPS_WEIGHT |
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+---------------------+---------------------+-------------+
| 1 | sys_unit_config | 2025-08-11 12:07:41.719946 | 2025-08-11 12:08:03.347411 | 2 | 2 | 1073741824 | 2147483648 | 9223372036854775807 | 9223372036854775807 | 2 |
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+---------------------+---------------------+-------------+
1 row in set (0.002 sec)
通过 GV$OB_UNITS 视图
通过 GV$OB_UNITS 视图，也可以查看节点的 Unit 信息。
SELECT * FROM GV$OB_UNITS;
输出结果如下：
obclient(root@sys)[oceanbase]> SELECT * FROM GV$OB_UNITS;
+-----------+----------+---------+-----------+-------+-----------+---------------+---------+---------+-------------+---------------------+---------------------+-------------+---------------+-----------------+------------------+--------+----------------------------+
| SVR_IP | SVR_PORT | UNIT_ID | TENANT_ID | ZONE | ZONE_TYPE | REGION | MAX_CPU | MIN_CPU | MEMORY_SIZE | MAX_IOPS | MIN_IOPS | IOPS_WEIGHT | LOG_DISK_SIZE | LOG_DISK_IN_USE | DATA_DISK_IN_USE | STATUS | CREATE_TIME |
+-----------+----------+---------+-----------+-------+-----------+---------------+---------+---------+-------------+---------------------+---------------------+-------------+---------------+-----------------+------------------+--------+----------------------------+
| 127.0.0.1 | 2882 | 1 | 1 | zone1 | ReadWrite | deault_region | 2 | 2 | 1073741824 | 9223372036854775807 | 9223372036854775807 | 2 | 2147483648 | 173299140 | 51757056 | NORMAL | 2025-08-11 12:06:49.158671 |
+-----------+----------+---------+-----------+-------+-----------+---------------+---------+---------+-------------+---------------------+---------------------+-------------+---------------+-----------------+------------------+--------+----------------------------+
1 row in set (0.003 sec)
查看资源分配信息
通过 GV$OB_SERVERS 视图，可以查看 OBServer 的信息。
SELECT * FROM GV$OB_SERVERS;
从查询结果看，节点 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）是 6442450944/1024/1024/1024 = 6G，已分配的内存（MEM_ASSIGNED）是 6442450944/1024/1024/1024 = 6G，日志盘总空间（LOG_DISK_CAPACITY）为 20401094656/1024/1024/1024 = 19G，已分配日志盘空间（LOG_DISK_ASSIGNED）是 20401094656/1024/1024/1024 = 19G，日志盘已使用（LOG_DISK_IN_USE） 603979776/1024/1024 = 576M，数据盘空间（DATA_DISK_CAPACITY） 149250113536/1024/1024/1024 = 139G，数据盘已使用（DATA_DISK_IN_USE） 98566144/1024/1024 = 94M。
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_IN_USE | DATA_DISK_HEALTH_STATUS | MEMORY_LIMIT | DATA_DISK_ALLOCATED | DATA_DISK_ABNORMAL_TIME | SSL_CERT_EXPIRED_TIME |
+-----------+----------+-------+----------+--------------+------------------+--------------+------------------+--------------+--------------+-------------------+-------------------+-----------------+--------------------+------------------+-------------------------+--------------+---------------------+-------------------------+-----------------------+
| 127.0.0.1 | 2882 | zone1 | 2881 | 8 | 8 | 2 | 2 | 6442450944 | 1073741824 | 20401094656 | 2147483648 | 201326592 | 149250113536 | 75497472 | NORMAL | 7516192768 | 2147483648 | NULL | NULL |
+-----------+----------+-------+----------+--------------+------------------+--------------+------------------+--------------+--------------+-------------------+-------------------+-----------------+--------------------+------------------+-------------------------+--------------+---------------------+-------------------------+-----------------------+
1 row in set (0.006 sec)
查询 Unit 列表
可以通过如下 SQL，查询当前集群的 unit 对应的租户、所在的主机等更详细的信息。
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.046 sec)
查看默认的租户信息
查看租户信息
通过 DBA_OB_TENANTS 视图，可以查看租户信息。
SELECT * FROM DBA_OB_TENANTS;
从查询结果看，默认创建的租户名称（TENANT_NAME ）是 sys，租户 ID（TENANT_ID ）是 1，租户类型（TENANT_TYPE）是 SYS 租户，租户的 PRIMARY_ZONE（PRIMARY_ZONE ）是 RANDOM ，租户副本分布（LOCALITY）在 zone1，兼容模式（COMPATIBILITY_MODE）是 MySQL，即默认创建的 SYS 租户为 MySQL 模式。
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 | FLASHBACK_LOG_SCN |
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------+-------------------+--------------------+--------+---------------+--------+-------------+-------------------+------------------+----------+----------------+--------------+--------------------+--------------+----------------------------+----------+------------+-----------+-------------------+
| 1 | sys | SYS | 2025-08-11 12:07:41.755044 | 2025-08-11 12:07:41.755044 | RANDOM | FULL{1}@zone1 | NULL | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | NULL | NULL | NULL | NULL | NOARCHIVELOG | DISABLED | 1 | 4.2.5.4 | 1 | NULL |
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------+-------------------+--------------------+--------+---------------+--------+-------------+-------------------+------------------+----------+----------------+--------------+--------------------+--------------+----------------------------+----------+------------+-----------+-------------------+
1 row in set (0.038 sec)
查看租户的资源单元部署位置
通过以下语句，查看当前已创建租户资源单元所在设备 IP 信息。
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;
从查询结果可以看出， SYS 租户对应的 ID 为 1，资源所在节点的 IP 为 127.0.0.1。
+-------------+-----------+-----------+
| TENANT_NAME | TENANT_ID | SVR_IP |
+-------------+-----------+-----------+
| sys | 1 | 127.0.0.1 |
+-------------+-----------+-----------+
1 row in set (0.014 sec)
查询数据库列表
可以通过如下 SQL，查询已存在的数据库的相关信息。
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 |
+---------------------+-------------+--------------------+----------------+--------------+-----------+
| 2025-08-11 12:07:42 | 201001 | oceanbase | 45 | NULL | 0 |
| 2025-08-11 12:07:42 | 201002 | information_schema | 45 | NULL | 0 |
| 2025-08-11 12:07:42 | 201003 | mysql | 45 | NULL | 0 |
| 2025-08-11 12:07:42 | 201004 | __recyclebin | 45 | NULL | 0 |
| 2025-08-11 12:07:42 | 201005 | __public | 45 | NULL | 0 |
| 2025-08-11 12:07:42 | 201006 | SYS | 45 | NULL | 0 |
| 2025-08-11 12:07:42 | 201007 | LBACSYS | 45 | NULL | 0 |
| 2025-08-11 12:07:42 | 201008 | ORAAUDITOR | 45 | NULL | 0 |
| 2025-08-11 12:07:42 | 500001 | test | 45 | NULL | 0 |
| 2025-08-11 12:08:02 | 500003 | sys_external_tbs | 45 | NULL | 0 |
| 2025-08-11 12:08:05 | 500005 | ocs | 45 | NULL | 0 |
+---------------------+-------------+--------------------+----------------+--------------+-----------+
11 rows in set (0.130 sec)
查看租户白名单
可以看出，默认的租户白名单为 %。
SHOW VARIABLES LIKE 'ob_tcp_invited_nodes';
输出结果如下：
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| ob_tcp_invited_nodes | % |
+----------------------+-------+
1 row in set
查看租户系统变量
由于当前安装的是 OceanBase 数据库开源版，而开源版仅支持 MySQL 模式，故本文档仅提供 MySQL 模式下租户系统变量的查询方法。
查询 Session 级别变量值
通过 INFORMATION_SCHEMA.SESSION_VARIABLES 视图查询 ob_query_timeout 的 Session 级别变量值。
SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME = 'ob_query_timeout';
输出结果如下：
obclient(root@sys)[oceanbase]> SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME = 'ob_query_timeout';
+------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+------------------+----------------+
| ob_query_timeout | 10000000 |
+------------------+----------------+
1 row in set (0.005 sec)
查询 Global 级别变量值
通过 INFORMATION_SCHEMA.GLOBAL_VARIABLES 视图查询 ob_query_timeout 的 Global 级别变量值。
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'ob_query_timeout';
输出结果如下：
obclient(root@sys)[oceanbase]> SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'ob_query_timeout';
+------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+------------------+----------------+
| ob_query_timeout | 10000000 |
+------------------+----------------+
1 row in set (0.005 sec)
查看集群配置项
通过 GV$OB_PARAMETERS 视图，查询集群的配置项。
SELECT * FROM GV$OB_PARAMETERS WHERE NAME LIKE '%syslog_level%';
输出结果如下：
obclient(root@sys)[oceanbase]> SELECT * FROM GV$OB_PARAMETERS WHERE NAME LIKE '%syslog_level%';
+-----------+----------+-------+---------+-----------+--------------+-----------+-------+------------------------------------------------------------------------------------------------------------------------------+----------+-------------------+---------------+-----------+
| SVR_IP | SVR_PORT | ZONE | SCOPE | TENANT_ID | NAME | DATA_TYPE | VALUE | INFO | SECTION | EDIT_LEVEL | DEFAULT_VALUE | ISDEFAULT |
+-----------+----------+-------+---------+-----------+--------------+-----------+-------+------------------------------------------------------------------------------------------------------------------------------+----------+-------------------+---------------+-----------+
| 127.0.0.1 | 2882 | zone1 | CLUSTER | NULL | syslog_level | NULL | WDIAG | specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. | OBSERVER | DYNAMIC_EFFECTIVE | WDIAG | YES |
+-----------+----------+-------+---------+-----------+--------------+-----------+-------+------------------------------------------------------------------------------------------------------------------------------+----------+-------------------+---------------+-----------+
1 row in set (0.009 sec)