Meet OceanBase AI Database, the unified database for operational data, real-time analytics, and AI. Explore ->

Start on Cloud

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All

BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All

PRODUCTS

OceanBase Cloud

OceanBase Database

Tools Connectors and Middleware

QUICK START

OceanBase Cloud OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Document Feedback

oceanbase.DBA_OB_TENANTS

Last Updated：2026-07-14 03:09:02 Updated

Note

This view is available starting with V4.0.0.

Overview

Displays the basic information of a tenant.

When querying this view from the sys tenant, it displays information for all tenants, including the sys tenant, user-created tenants (user tenants), and the meta tenant. You can distinguish between tenant types based on the TENANT_TYPE column.
When you query this view from a regular tenant, only information of the current tenant is displayed.

Columns

Column	Type	Nullable	Description
TENANT_ID	bigint(20)	NO	Tenant ID: 1: system tenant ID Other values: user tenant or meta tenant ID
TENANT_NAME	varchar(128)	NO	Tenant Name
TENANT_TYPE	varchar(4)	NO	`SYS`: system tenant `USER`: User tenant `META`: Meta Tenant
CREATE_TIME	timestamp(6)	YES	Tenant creation time
MODIFY_TIME	timestamp(6)	YES	Information Update Time
PRIMARY_ZONE	varchar(128)	YES	Tenant Primary Zone
LOCALITY	varchar(4096)	NO	Tenant Replica Distribution Information
PREVIOUS_LOCALITY	varchar(4096)	NO	Locality information before the change: If this value is valid, the locality change has not been completed. NULL indicates no locality change was performed.
COMPATIBILITY_MODE	varchar(6)	NO	`MYSQL`: MySQL-compatible mode `ORACLE`: Oracle compatible mode
STATUS	varchar(64)	NO	Current tenant status: `NORMAL`: Normal tenant status. `RESTORE`: Tenant in physical restore `CREATING`: Tenant is being created. `DROPPING`
IN_RECYCLEBIN	varchar(3)	NO	Whether it is in the recycle bin: `YES`: In the recycle bin `NO`: Not in Recycle Bin
LOCKED	varchar(3)	NO	Lock status: `YES`: locked status. `NO`: Not locked. Passed`ALTER TENANT xxx LOCK\|UNLOCK`commands to affect field values
TENANT_ROLE	varchar(100)	NO	Cluster roles: `PRIMARY`: Primary tenant `STANDBY`: standby tenant `RESTORE`: The tenant is being restored. Note This field is available starting with V4.1.0.
SWITCHOVER_STATUS	varchar(100)	NO	SWITCHOVER Status: `NORMAL`: Normal, not in the process of switching. `PREPARE SWITCHING TO PRIMARY`: Prepare for standby-to-primary switchover `SWITCHING TO PRIMARY`: Standby Switchover Status `PREPARE FLASHBACK`: Prepare for flashback state. `FLASHBACK`: Flashback status `PREPARE SWITCHING TO STANDBY`: Prepare for primary-to-standby switchover. `SWITCHING TO STANDBY`: Primary to Standby Status Note This field is available starting with V4.1.0.
SWITCHOVER_EPOCH	bigint(20)	NO	Unique identifier for the SWITCHOVER/FAILOVER operation. Note This field is available starting with V4.1.0.
SYNC_SCN	bigint(20) unsigned	NO	The version of the snapshot that has been synchronized for the current tenant. This field is meaningless for the sys tenant and meta tenant, and is displayed as NULL. Note This field is available starting with V4.1.0.
REPLAYABLE_SCN	bigint(20) unsigned	NO	The current tenant can replay snapshot versions, which is meaningless for the system tenant and Meta tenant, so it displays as NULL. Note This field is available starting with V4.1.0.
READABLE_SCN	bigint(20) unsigned	NO	The readable snapshot version of the current tenant. This field is meaningless for the sys tenant and meta tenant, and is displayed as NULL. Note This field is available starting with V4.1.0.
RECOVERY_UNTIL_SCN	bigint(20) unsigned	NO	Maximum restore point of the current tenant. This field is meaningless for the sys tenant and meta tenant, and is displayed as NULL. Note This field is available starting with V4.1.0.
LOG_MODE	varchar(100)	NO	Archive mode: `ARCHIVELOG`: Archiving mode is enabling. `NOARCHIVELOG`: Archiving mode is not enabled. Note This field is available starting with V4.1.0.
ARBITRATION_SERVICE_STATUS	varchar(64)	NO	The arbitration service status of the tenant. Valid values: `ENABLING`: Enabling `ENABLED`: Completed `DISABLING`: Closing `DISABLED`: Close completed Note This field is available starting with V4.1.0.
UNIT_NUM	bigint(20)	NO	Zones of the Tenant`UNIT_NUM`Minimum Value of Note This field is available starting with V4.2.0. In V4.2.5, for versions earlier than V4.2.5 BP5, this field indicates the`UNIT_NUM`Value; for V4.2.5 BP5 and later, this field indicates the number of zones in each zone of the tenant.`UNIT_NUM`
ZONE_UNIT_NUM_LIST	varchar(65536)	NO	Displays the number of units in each zone of a tenant. Note This field is available starting with V4.2.5 BP5.
COMPATIBLE	varchar(65536)	NO	Compatibility Version Note This field is available starting with V4.2.0.
MAX_LS_ID	bigint(20)	NO	The largest log stream ID that the tenant has ever had. For the system tenant and Meta tenant, this value is 1; for user tenants, it is the actual size. Note This field is available starting with V4.2.0.
FLASHBACK_LOG_SCN	bigint(20)	NO	The timestamp of the last log trimming for the tenant. After a failover, you can use an O&M command to trim the standby tenant's logs to this point and promote the original standby tenant to the new primary tenant. Note This field is available starting with V4.2.5 BP4.

Sample query

The sys tenant can view the basic information of all tenants.

obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_TENANTS\G

The query result is as follows:

*************************** 1. row ***************************
                 TENANT_ID: 1
               TENANT_NAME: sys
               TENANT_TYPE: SYS
               CREATE_TIME: 2025-06-20 11:04:44.588357
               MODIFY_TIME: 2025-06-20 11:04:44.588357
              PRIMARY_ZONE: RANDOM
                  LOCALITY: FULL{1}@z1
         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
                  UNIT_NUM: 1
        ZONE_UNIT_NUM_LIST: z1:1
                COMPATIBLE: 4.2.5.5
                 MAX_LS_ID: 1
         FLASHBACK_LOG_SCN: NULL
*************************** 2. row ***************************
                 TENANT_ID: 1007
               TENANT_NAME: META$1008
               TENANT_TYPE: META
               CREATE_TIME: 2025-06-10 21:55:14.619101
               MODIFY_TIME: 2025-06-16 14:00:40.697060
              PRIMARY_ZONE: z1,z2
                  LOCALITY: FULL{1}@z1, FULL{1}@z2
         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
                  UNIT_NUM: 2
        ZONE_UNIT_NUM_LIST: z1:2,z2:2
                COMPATIBLE: 4.2.5.5
                 MAX_LS_ID: 1
         FLASHBACK_LOG_SCN: NULL
*************************** 3. row ***************************
                 TENANT_ID: 1008
               TENANT_NAME: tenant1
               TENANT_TYPE: USER
               CREATE_TIME: 2025-06-10 21:55:14.624399
               MODIFY_TIME: 2025-06-16 14:00:40.691794
              PRIMARY_ZONE: z1,z2
                  LOCALITY: FULL{1}@z1, FULL{1}@z2
         PREVIOUS_LOCALITY: NULL
        COMPATIBILITY_MODE: MYSQL
                    STATUS: NORMAL
             IN_RECYCLEBIN: NO
                    LOCKED: NO
               TENANT_ROLE: PRIMARY
         SWITCHOVER_STATUS: NORMAL
          SWITCHOVER_EPOCH: 0
                  SYNC_SCN: 1750060170009596000
            REPLAYABLE_SCN: 1750060170009596000
              READABLE_SCN: 1750060169907507000
        RECOVERY_UNTIL_SCN: 4611686018427387903
                  LOG_MODE: NOARCHIVELOG
ARBITRATION_SERVICE_STATUS: DISABLED
                  UNIT_NUM: 2
        ZONE_UNIT_NUM_LIST: z1:2,z2:2
                COMPATIBLE: 4.2.5.5
                 MAX_LS_ID: 1018
         FLASHBACK_LOG_SCN: NULL
3 rows in set

References

Tenant types