Note
This view is available starting with V4.0.0.
Purpose
This view displays the basic information of a tenant.
- When you query this view as the system tenant, the information of all tenants, including the system tenant, user-created tenants (user tenants), and the Meta tenant, is displayed. You can use the
TENANT_TYPEcolumn to identify the type of each tenant. - When you query this view as a user tenant, only the information of the user tenant is displayed.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID.
|
| TENANT_NAME | VARCHAR2(128) | NO | The tenant name. |
| TENANT_TYPE | VARCHAR2(4) | NO |
|
| 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 information was updated. |
| PRIMARY_ZONE | VARCHAR2(128) | YES | The primary zone of the tenant. |
| LOCALITY | VARCHAR2(4096) | YES | The distribution information of tenant replicas. |
| PREVIOUS_LOCALITY | VARCHAR2(4096) | YES | The locality information before the change.
|
| COMPATIBILITY_MODE | VARCHAR2(6) | NO |
|
| STATUS | VARCHAR2(64) | NO | The current tenant status.
|
| IN_RECYCLEBIN | VARCHAR2(3) | NO | Indicates whether the tenant is in the recycle bin.
|
| LOCKED | VARCHAR2(3) | NO | Indicates whether the tenant is locked.
ALTER TENANT xxx LOCK|UNLOCK statement. |
| TENANT_ROLE | VARCHAR2(100) | NO | The cluster role.
NoteThis field is available starting with V4.1.0. |
| SWITCHOVER_STATUS | VARCHAR2(100) | NO | The SWITCHOVER status.
NoteThis field is available starting with V4.1.0. |
| SWITCHOVER_EPOCH | NUMBER | NO | The unique identifier of SWITCHOVER/FAILOVER.
NoteThis field is available starting with V4.1.0. |
| SYNC_SCN | NUMBER | NO | The snapshot version that is synchronized for the current tenant. For the system tenant and the Meta tenant, this field is meaningless and is displayed as NULL.
NoteThis field is available starting with V4.1.0. |
| REPLAYABLE_SCN | NUMBER | NO | The snapshot version that can be replayed for the current tenant. For the system tenant and the Meta tenant, this field is meaningless and is displayed as NULL.
NoteThis field is available starting with V4.1.0. |
| READABLE_SCN | NUMBER | NO | The snapshot version that can be read for the current tenant. For the system tenant and the Meta tenant, this field is meaningless and is displayed as NULL.
NoteThis field is available starting with V4.1.0. |
| RECOVERY_UNTIL_SCN | NUMBER | NO | The maximum recovery point for the current tenant. For the system tenant and the Meta tenant, this field is meaningless and is displayed as NULL.
NoteThis field is available starting with V4.1.0. |
| LOG_MODE | VARCHAR2(100) | NO | The archive mode.
NoteThis field is available starting with V4.1.0. |
| ARBITRATION_SERVICE_STATUS | VARCHAR2(64) | NO | The arbitration service status of the tenant. Valid values:
NoteThis field is available starting with V4.1.0. |
| UNIT_NUM | NUMBER(38) | NO | The minimum value of the UNIT_NUM of all zones of the tenant.
Note
|
| ZONE_UNIT_NUM_LIST | VARCHAR2(32767) | NO | The number of units in each zone of the tenant.
Note
|
| COMPATIBLE | VARCHAR2(65536) | NO | The compatibility version.
NoteThis column is available starting with V4.2.0. |
| MAX_LS_ID | NUMBER | NO | The maximum log stream ID that has ever existed for the tenant. For the system tenant and the meta tenant, the value is 1. For a user tenant, the value is the actual size.
NoteThis column is available starting with V4.2.0. |
| RESTORE_DATA_MODE | VARCHAR2(128) | NO | The data restore mode of the tenant. Valid values:
NoteThis column is available starting with V4.3.2. |
| FLASHBACK_LOG_SCN | NUMBER | NO | The latest log stream ID that has ever existed for the tenant. After a failover, you can execute an operation command to enable the standby tenant to be connected to the new primary tenant.
NoteThis column is available starting with V4.4.1. |
| COMMENT | VARCHAR2(4096) | NO | The comment. |
| PROTECTION_MODE | VARCHAR2(128) | NO | The protection mode of the tenant. Only the MAXIMUM PERFORMANCE (maximum performance) protection mode is supported.
NoteThis column is available starting with V4.6.0. |
| PROTECTION_LEVEL | VARCHAR2(128) | NO | The protection level of the tenant. Only the MAXIMUM PERFORMANCE (maximum performance) protection level is supported.
NoteThis column is available starting with V4.6.0. |
Sample query
A user tenant queries the information about the user tenant.
obclient(SYS@oracle001)[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: 16-MAR-26 04.32.16.239476 PM
MODIFY_TIME: 16-MAR-26 04.32.22.233799 PM
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: 1774943484904258000
REPLAYABLE_SCN: 1774943484904258000
READABLE_SCN: 1774943484904258000
RECOVERY_UNTIL_SCN: 4611686018427387903
LOG_MODE: NOARCHIVELOG
ARBITRATION_SERVICE_STATUS: DISABLED
UNIT_NUM: 1
ZONE_UNIT_NUM_LIST: zone1:1
COMPATIBLE: 4.6.0.0
MAX_LS_ID: 1001
RESTORE_DATA_MODE: NORMAL
FLASHBACK_LOG_SCN: NULL
COMMENT: NULL
PROTECTION_MODE: MAXIMUM PERFORMANCE
PROTECTION_LEVEL: MAXIMUM PERFORMANCE
1 row in set