【OceanBase】查看 OceanBase 集群基本信息17认证网

正规官方授权
更专业・更权威
当前位置： 首页 > OceanBase认证 > 技术资料 > 正文

【OceanBase】查看 OceanBase 集群基本信息

2026-04-09 来源：sean 分类：技术资料 阅读(9)

OceanBase 单机版部署

OceanBase 单机版部署参考

查看集群基本信息

连接集群

obclient -h192.*.*.60 -P2881 -uroot@sys -p'********' -Doceanbase -A

执行结果如下：

[admin@ocean ~]$ obclient -h192.*.*.60 -P2881 -uroot@sys -p'********' -Doceanbase -A
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 3221493463
Server version: OceanBase_CE 4.3.5.5 (r105010032025121323-524cb9015f8e905b5361bd410f99cf97c7df6557) (Built Dec 13 2025 23:37:29)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient(root@sys)[oceanbase]>

查看集群默认创建的 Zone 信息

SELECT * FROM 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-01-13 15:57:16.748758 | 2026-01-13 15:57:21.107644 | ACTIVE | default_idc | deault_region | ReadWrite |
+-------+----------------------------+----------------------------+--------+-------------+---------------+-----------+
1 row in set (0.018 sec)obclient(root@sys)[oceanbase]>

从查询结果可以看到，使用 all_in_one 包创建单机版 OceanBase 集群后，在本机上默认创建一个 Zone，该 Zone 为读写类型的可用状态，所在地为 deault_region，机房为 default_idc。

查看默认的节点

可以通过查询 oceanbase.DBA_OB_SERVERS 视图，获取集群中的节点信息。

SELECT * FROM oceanbase.DBA_OB_SERVERS;

执行结果如下：

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 |
+----------------+----------+------+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+-------------------+
| 192.*.*.60 | 2882 | 1 | zone1 | 2881 | YES | ACTIVE | 2026-04-08 11:03:39.489133 | NULL | NULL | 2026-01-13 15:57:17.874783 | 2026-04-08 11:03:40.652769 | 4.3.5.5_105010032025121323-524cb9015f8e905b5361bd410f99cf97c7df6557(Dec 13 2025 23:37:29) | NULL |
+----------------+----------+------+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+-------------------+
1 row in set (0.002 sec) 

从查询结果看，默认创建一个本地的节点，IP 为 192...60，默认的节点端口号为 2881，RPC 端口号为 2882，节点位于之前查到的 zone1 上，该节点是集群的 RS，是可用状态。

查看默认的资源信息

查看默认的资源池信息

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

SELECT * FROM oceanbase.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-01-13 15:57:16.258055 | 2026-01-13 15:57:16.264535 | 1 | 1 | zone1 | FULL |
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-----------+--------------+
1 row in set (0.002 sec)obclient(root@sys)[oceanbase]>

从查询结果看，默认的资源池（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。

查看默认的资源规格信息

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

SELECT * FROM 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-01-13 15:57:16.253664 | 2026-01-13 15:57:16.253664 | 1 | 1 | 2147483648 | 2147483648 | NULL | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 |
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+----------------+---------------------+---------------------+-------------+---------------------+----------------------+
1 row in set (0.002 sec)obclient(root@sys)[oceanbase]>

从查询结果看，默认创建的资源规格（UNIT_CONFIG_ID）名称是 sys_unit_config，资源规格 ID（UNIT_CONFIG_ID）是 1，CPU 规格上限（MAX_CPU）是 1C，内存规格（MEMORY_SIZE）是 2147483648/1024/1024/1024 = 2G，日志盘空间（LOG_DISK_SIZE）是 2147483648/1024/1024/1024 = 2G。
通过 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 | MAX_NET_BANDWIDTH | NET_BANDWIDTH_WEIGHT | LOG_DISK_SIZE | LOG_DISK_IN_USE | DATA_DISK_SIZE | DATA_DISK_IN_USE | STATUS | CREATE_TIME |
+----------------+----------+---------+-----------+-------+-----------+---------------+---------+---------+-------------+---------------------+---------------------+-------------+---------------------+----------------------+---------------+-----------------+----------------+------------------+--------+----------------------------+
| 192.*.*.60 | 2882 | 1 | 1 | zone1 | ReadWrite | deault_region | 1 | 1 | 2147483648 | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | 2147483648 | 389316110 | NULL | 133156864 | NORMAL | 2026-01-13 15:57:10.704481 |
+----------------+----------+---------+-----------+-------+-----------+---------------+---------+---------+-------------+---------------------+---------------------+-------------+---------------------+----------------------+---------------+-----------------+----------------+------------------+--------+----------------------------+
1 row in set (0.004 sec)obclient(root@sys)[oceanbase]>

查看资源分配信息

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

SELECT * FROM GV$OB_SERVERS;

 

执行结果如下：

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 |
+----------------+----------+-------+----------+--------------+------------------+--------------+------------------+--------------+--------------+-------------------+-------------------+-----------------+--------------------+--------------------+------------------+-------------------------+--------------+---------------------+-------------------------+-----------------------+----------------------------------+-----------------------------+
| 192.*.*.60 | 2882 | zone1 | 2881 | 2 | 2 | 1 | 1 | 5471692390 | 2147483648 | 96569655296 | 2147483648 | 402653184 | 193179156480 | NULL | 155189248 | NORMAL | 6545434214 | 193179156480 | NULL | NULL | NULL | NULL |
+----------------+----------+-------+----------+--------------+------------------+--------------+------------------+--------------+--------------+-------------------+-------------------+-----------------+--------------------+--------------------+------------------+-------------------------+--------------+---------------------+-------------------------+-----------------------+----------------------------------+-----------------------------+
1 row in set (0.001 sec)obclient(root@sys)[oceanbase]>

从查询结果看，节点 IP（SVR_IP）是 192...60，服务器端口号（SVR_PORT）是 2882，对应的 zone 名称（zone）是 zone1，SQL 端口（SQL_PORT）是 2881，observer 进程可用的 CPU 数量（CPU_CAPACITY）是 2C，observer 进程可用的内存（MEM_CAPACITY）是 5471692390/1024/1024/1024 = 5G，已分配的内存（MEM_ASSIGNED）是 2147483648/1024/1024/1024 = 2G，日志盘总空间（LOG_DISK_CAPACITY）为 96569655296/1024/1024/1024 = 90G，已分配日志盘空间（LOG_DISK_ASSIGNED）是 2147483648/1024/1024/1024 = 2G，日志盘已使用（LOG_DISK_IN_USE） 402653184/1024/1024 = 384M，数据盘空间（DATA_DISK_CAPACITY） 193179156480/1024/1024/1024 = 179G，数据盘已使用（DATA_DISK_IN_USE） 155189248/1024/1024 = 148M。

查询 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; 

执行结果如下：

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 | 192.*.*.60 | 2882 | ACTIVE | FULL | 1 | sys | sys_pool | NULL | NULL | NULL |
+---------+------------------+-------+----------------+----------+--------+--------------+-----------+-------------+--------------------+---------------------+-----------------------+----------------+
1 row in set (0.024 sec)obclient(root@sys)[oceanbase]>

查看默认的租户信息

查看租户信息

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

SELECT * FROM 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 | COMMENT |
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------+-------------------+--------------------+--------+---------------+--------+-------------+-------------------+------------------+----------+----------------+--------------+--------------------+--------------+----------------------------+----------+------------+-----------+-------------------+---------------+
| 1 | sys | SYS | 2026-01-13 15:57:16.287336 | 2026-01-13 15:57:16.287336 | RANDOM | FULL{1}@zone1 | NULL | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | NULL | NULL | NULL | NULL | NOARCHIVELOG | DISABLED | 1 | 4.3.5.5 | 1 | NORMAL | system tenant |
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------+-------------------+--------------------+--------+---------------+--------+-------------+-------------------+------------------+----------+----------------+--------------+--------------------+--------------+----------------------------+----------+------------+-----------+-------------------+---------------+
1 row in set (0.041 sec)obclient(root@sys)[oceanbase]>

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

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

通过以下语句，查看当前已创建租户资源单元所在设备 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;

 

执行结果如下：

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 | 192.*.*.60 |
+-------------+-----------+----------------+
1 row in set (0.008 sec)obclient(root@sys)[oceanbase]>

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

查询数据库列表

可以通过如下 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'; 

执行结果如下：

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-01-13 15:57:17 | 201001 | oceanbase | 45 | NULL | 0 |
| 2026-01-13 15:57:17 | 201002 | information_schema | 45 | NULL | 0 |
| 2026-01-13 15:57:17 | 201003 | mysql | 45 | NULL | 0 |
| 2026-01-13 15:57:17 | 201004 | __recyclebin | 45 | NULL | 0 |
| 2026-01-13 15:57:17 | 201005 | __public | 45 | NULL | 0 |
| 2026-01-13 15:57:17 | 201006 | SYS | 45 | NULL | 0 |
| 2026-01-13 15:57:17 | 201007 | LBACSYS | 45 | NULL | 0 |
| 2026-01-13 15:57:17 | 201008 | ORAAUDITOR | 45 | NULL | 0 |
| 2026-01-13 15:57:17 | 500001 | test | 45 | NULL | 0 |
| 2026-01-13 15:57:20 | 500002 | sys_external_tbs | 45 | NULL | 0 |
| 2026-01-13 15:57:23 | 500004 | ocs | 45 | NULL | 0 |
+---------------------+-------------+--------------------+----------------+--------------+-----------+
11 rows in set (0.098 sec)obclient(root@sys)[oceanbase]>

查看租户白名单

可以看出，默认的租户白名单为 %。

SHOW VARIABLES LIKE 'ob_tcp_invited_nodes';

 

执行结果如下：

obclient(root@sys)[oceanbase]> SHOW VARIABLES LIKE 'ob_tcp_invited_nodes';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| ob_tcp_invited_nodes | % |
+----------------------+-------+
1 row in set (0.012 sec)

查看租户系统变量

由于当前安装的是 OceanBase 数据库开源版，而开源版仅支持 MySQL 模式，故本文档仅提供 MySQL 模式下租户系统变量的查询方法。

  • 通过 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)obclient(root@sys)[oceanbase]>

  • 通过 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.012 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 |
+----------------+----------+-------+---------+-----------+--------------+-----------+-------+------------------------------------------------------------------------------------------------------------------------------+----------+-------------------+---------------+-----------+
| 192.*.*.60 | 2882 | zone1 | CLUSTER | NULL | syslog_level | STRING | 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.013 sec)obclient(root@sys)[oceanbase]>

关于作者

网名：飞天，墨天轮2024年度、2025年度优秀原创作者，拥有 Oracle 10g OCM 认证、PGCE认证、MySQL 8.0 OCP认证以及OBCA、KCP、KCSM、ACP、YCP、HCIP-openGauss、HCCDP-GaussDB、磐维等众多国产数据库认证证书，目前从事Oracle、Mysql、PostgreSQL、磐维数据库管理运维工作，喜欢结交更多志同道合的朋友，热衷于研究、分享数据库技术。
微信公众号：飞天online
墨天轮：https://www.modb.pro/u/15197

想了解更多干货，可通过下方扫码关注

可扫码添加上智启元官方客服微信👇

未经允许不得转载：17认证网 » 【OceanBase】查看 OceanBase 集群基本信息
分享到：0
标签：

评论已关闭。

热门推荐

点击进群免费领学习资料，获取最新战报

首页右侧广告

热门标签

研报 研究报告 行业动态 学习资料 技术资料 MySQL 实时战报 上智战报 Oracle Mysql战报 考点查询 Oceanbase 华为 Oracle战报 linux 红帽 腾讯云 常见问题 红帽战报 运维 红帽常见问题 考试指南 数据库 ITIL Oracle常见问题 DevOps 优惠券 特价报考 讲师 OceanBase常见问题 MySQL常见问题 云原生 SQL 置顶 pg 红帽考试指南 OBCA AIGC PostgreSQL 私域 考试流程 安装包 红帽系统 ISO RHEL9 OBCP AI java 云计算 国产数据库 K8S 阿里云 系统镜像 报名 RHCE 红帽9.0 RHEL MySQL考试指南 OCM OCM考试指南 在线考试攻略 OCP考试指南 数字化 OBCA考试指南 OBCP考试指南 OBCE考试指南 OBCE OCP 开源软件 GreatSQL 火山引擎 开源数据库 医美 电商 MySQL备考攻略 MySQL真题 PostgresSQL CentOS9.0 CentOS RHEL7 RHEL8 新华三 人工智能 OBCA战报 云原生数据仓库 红帽考场攻略
华为考点查询
Oracle考点查询
OceanBase考点查询
红帽考点查询
腾讯云考点查询
学习资源下载

推荐文章

400-663-6632
咨询老师
咨询老师
咨询老师