Note
This view was introduced in OceanBase Database V4.0.0.
Purpose
The DBA_OB_TENANTS view displays the basic information of tenants.
- When you query this view from the
systenant, the view displays the basic information of all tenants, including thesystenant, user tenants, and meta tenants. You can determine the tenant type based on theTENANT_TYPEcolumn. - When you query this view from a user tenant, only the information of the current tenant is displayed.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant. Valid values:
|
| TENANT_NAME | VARCHAR2(128) | NO | The name of the tenant. |
| TENANT_TYPE | VARCHAR2(4) | NO | The type of the tenant. Valid values:
|
| CREATE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the tenant was created. |
| MODIFY_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the tenant was last modified. |
| PRIMARY_ZONE | VARCHAR2(128) | YES | The primary zone of the tenant. |
| LOCALITY | VARCHAR2(4096) | YES | The locality of the tenant. |
| PREVIOUS_LOCALITY | VARCHAR2(4096) | YES | The locality before the change.
|
| COMPATIBILITY_MODE | VARCHAR2(6) | NO | The compatibility mode. Valid values:
|
| STATUS | VARCHAR2(64) | NO | The current status of the tenant. Valid values:
|
| IN_RECYCLEBIN | VARCHAR2(3) | NO | Indicates whether the tenant has been dropped and is in the recycle bin. Valid values:
|
| LOCKED | VARCHAR2(3) | NO | Indicates whether the tenant is locked. Valid values:
ALTER TENANT xxx LOCK|UNLOCK command. |
| TENANT_ROLE | VARCHAR2(100) | NO | The role of the tenant in the cluster. Valid values:
NoteThis column is available in OceanBase Database V4.1.0 and later. |
| SWITCHOVER_STATUS | VARCHAR2(100) | NO | The switchover status. Valid values:
NoteThis column is available in OceanBase Database V4.1.0 and later. |
| SWITCHOVER_EPOCH | NUMBER | NO | The unique ID of the switchover or failover.
NoteThis column is available in OceanBase Database V4.1.0 and later. |
| SYNC_SCN | NUMBER | NO | The snapshot version that has been synchronized for the current tenant. The value is NULL for the sys tenant or a meta tenant.
NoteThis column is available in OceanBase Database V4.1.0 and later. |
| REPLAYABLE_SCN | NUMBER | NO | The snapshot version that can be replayed for the current tenant. The value is NULL for the sys tenant or a meta tenant.
NoteThis column is available in OceanBase Database V4.1.0 and later. |
| READABLE_SCN | NUMBER | NO | The snapshot version that can be read for the current tenant. The value is NULL for the sys tenant or a meta tenant.
NoteThis column is available in OceanBase Database V4.1.0 and later. |
| RECOVERY_UNTIL_SCN | NUMBER | NO | The maximum system change number (SCN) that can be restored for the current tenant. The value is NULL for the sys tenant or a meta tenant.
NoteThis column is available in OceanBase Database V4.1.0 and later. |
| LOG_MODE | VARCHAR2(100) | NO | The log archiving mode. Valid values:
NoteThis column is available in OceanBase Database V4.1.0 and later. |
| ARBITRATION_SERVICE_STATUS | VARCHAR2(64) | NO | The arbitration service status of the tenant. Valid values:
NoteThis column is available in OceanBase Database V4.1.0 and later. |
| UNIT_NUM | NUMBER(38) | NO | The number of resource units in each zone.
NoteThis column is available in OceanBase Database V4.2.0 and later. |
| COMPATIBLE | VARCHAR2(65536) | NO | The compatibility version.
NoteThis column is available in OceanBase Database V4.2.0 and later. |
| MAX_LS_ID | NUMBER | NO | The maximum log stream ID of the tenant. The value is 1 for the sys tenant or a meta tenant. For a user tenant, the value varies based on the actual situation.
NoteThis column is available in OceanBase Database V4.2.0 and later. |
| RESTORE_DATA_MODE | varchar(128) | NO | The data restore mode of the tenant. Valid values:
NoteThis column is available in OceanBase Database V4.3.3 and later. |
Sample query
Query the tenant information of a user tenant from the user tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_TENANTS\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1004
TENANT_NAME: oracle001
TENANT_TYPE: USER
CREATE_TIME: 08-AUG-24 10.28.52.519229 AM
MODIFY_TIME: 08-AUG-24 10.29.14.902080 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: 1723169940678411001
REPLAYABLE_SCN: 1723169940678411001
READABLE_SCN: 1723169940678411000
RECOVERY_UNTIL_SCN: 4611686018427387903
LOG_MODE: NOARCHIVELOG
ARBITRATION_SERVICE_STATUS: DISABLED
UNIT_NUM: 1
COMPATIBLE: 4.3.2.1
MAX_LS_ID: 1001
RESTORE_DATA_MODE: NORMAL
1 row in set