查看租户信息

您可以通过 SQL 语句查看租户的信息。

查看所有租户信息

sys 租户可以通过视图 oceanbase.DBA_OB_TENANTS 来查看集群中的租户信息，包括各租户的 ID、名称、Primary Zone 以及副本分布方式等。

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

2. 执行以下语句，查看当前集群中的租户信息。

   示例如下：

   obclient> SELECT * FROM oceanbase.DBA_OB_TENANTS\G
   *************************** 1. row ***************************
                    TENANT_ID: 1
                  TENANT_NAME: sys
                  TENANT_TYPE: SYS
                  CREATE_TIME: 2023-02-06 11:50:21.843349
                  MODIFY_TIME: 2023-02-06 11:51:17.054689
                 PRIMARY_ZONE: zone1
                     LOCALITY: FULL{1}@zone1
            PREVIOUS_LOCALITY: NULL
           COMPATIBILITY_MODE: MYSQL
                       STATUS: NORMAL
                IN_RECYCLEBIN: NO
                       LOCKED: NO
                  TENANT_ROLE: PRIMARY
            SWITCHOVER_STATUS: NORMAL
             SWITCHOVER_EPOCH: 0
                     SYNC_SCN: NULL
               REPLAYABLE_SCN: NULL
                 READABLE_SCN: NULL
           RECOVERY_UNTIL_SCN: NULL
                     LOG_MODE: NOARCHIVELOG
   ARBITRATION_SERVICE_STATUS: DISABLED
   *************************** 2. row ***************************
                    TENANT_ID: 1001
                  TENANT_NAME: META$1002
                  TENANT_TYPE: META
                  CREATE_TIME: 2023-02-06 13:38:03.410324
                  MODIFY_TIME: 2023-02-06 13:38:19.535303
                 PRIMARY_ZONE: zone1
                     LOCALITY: FULL{1}@zone1
            PREVIOUS_LOCALITY: NULL
           COMPATIBILITY_MODE: MYSQL
                       STATUS: NORMAL
                IN_RECYCLEBIN: NO
                       LOCKED: NO
                  TENANT_ROLE: PRIMARY
            SWITCHOVER_STATUS: NORMAL
             SWITCHOVER_EPOCH: 0
                     SYNC_SCN: NULL
               REPLAYABLE_SCN: NULL
                 READABLE_SCN: NULL
           RECOVERY_UNTIL_SCN: NULL
                     LOG_MODE: NOARCHIVELOG
   ARBITRATION_SERVICE_STATUS: DISABLED
   *************************** 3. row ***************************
                    TENANT_ID: 1002
                  TENANT_NAME: mysql001
                  TENANT_TYPE: USER
                  CREATE_TIME: 2023-02-06 13:38:03.416572
                  MODIFY_TIME: 2023-02-06 13:38:19.565811
                 PRIMARY_ZONE: zone1
                     LOCALITY: FULL{1}@zone1
            PREVIOUS_LOCALITY: NULL
           COMPATIBILITY_MODE: MYSQL
                       STATUS: NORMAL
                IN_RECYCLEBIN: NO
                       LOCKED: NO
                  TENANT_ROLE: PRIMARY
            SWITCHOVER_STATUS: NORMAL
             SWITCHOVER_EPOCH: 0
                     SYNC_SCN: 1678328804810378183
               REPLAYABLE_SCN: 1678328804810378183
                 READABLE_SCN: 1678328804601007064
           RECOVERY_UNTIL_SCN: 4611686018427387903
                     LOG_MODE: NOARCHIVELOG
   ARBITRATION_SERVICE_STATUS: DISABLED
   3 rows in set
   

   更多视图 oceanbase.DBA_OB_TENANTS 的字段说明信息请参见 DBA_OB_TENANTS。

查看当前租户信息

所有用户均可以查看当前租户的信息，包括租户名、租户 ID、租户状态等。

1. 用户租户登录到数据库。

2. 执行以下语句，查看当前租户信息。

   示例如下：

   obclient [SYS]> SELECT * FROM DBA_OB_TENANTS;
   *************************** 1. row ***************************
            TENANT_ID: 1004
          TENANT_NAME: oracle001
          TENANT_TYPE: USER
          CREATE_TIME: 13-MAR-23 10.23.07.538516 AM
          MODIFY_TIME: 13-MAR-23 10.23.25.073040 AM
         PRIMARY_ZONE: zone1
             LOCALITY: FULL{1}@zone1
    PREVIOUS_LOCALITY: NULL
   COMPATIBILITY_MODE: ORACLE
               STATUS: NORMAL
        IN_RECYCLEBIN: NO
               LOCKED: NO
          TENANT_ROLE: PRIMARY
    SWITCHOVER_STATUS: NORMAL
     SWITCHOVER_EPOCH: 0
             SYNC_SCN: 1679392361895209460
       REPLAYABLE_SCN: 1679392361895209460
         READABLE_SCN: 1679392361804500893
   RECOVERY_UNTIL_SCN: 4611686018427387903
             LOG_MODE: NOARCHIVELOG
   1 row in set