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 from the system tenant, the information of all tenants is displayed, including the system tenant, user-created tenant (user tenant), and Meta tenant. You can use the
TENANT_TYPEcolumn to distinguish the types of tenants. - When you query this view from a user tenant, only the information of this tenant is displayed.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | Tenant ID:
|
| TENANT_NAME | VARCHAR2(128) | NO | Tenant name |
| TENANT_TYPE | VARCHAR2(4) | NO |
|
| CREATE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | Tenant creation time |
| MODIFY_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | Information update time |
| PRIMARY_ZONE | VARCHAR2(128) | YES | Tenant primary zone |
| LOCALITY | VARCHAR2(4096) | YES | Tenant replica distribution information |
| PREVIOUS_LOCALITY | VARCHAR2(4096) | YES | Locality information before the change:
|
| COMPATIBILITY_MODE | VARCHAR2(6) | NO |
|
| STATUS | VARCHAR2(64) | NO | Current tenant status:
|
| IN_RECYCLEBIN | VARCHAR2(3) | NO | Whether the tenant is in the recycle bin:
|
| LOCKED | VARCHAR2(3) | NO | Whether the tenant is locked:
ALTER TENANT xxx LOCK|UNLOCK statement. |
| TENANT_ROLE | VARCHAR2(100) | NO | Cluster role:
NoteThis column is available starting with V4.1.0. |
| SWITCHOVER_STATUS | VARCHAR2(100) | NO | SWITCHOVER status:
NoteThis column is available starting with V4.1.0. |
| SWITCHOVER_EPOCH | NUMBER | NO | Unique identifier for SWITCHOVER/FAILOVER
NoteThis column is available starting with V4.1.0. |
| SYNC_SCN | NUMBER | NO | Snapshot version that has been synchronized for the current tenant. For system tenants and Meta tenants, this column is meaningless and displays as NULL
NoteThis column is available starting with V4.1.0. |
| REPLAYABLE_SCN | NUMBER | NO | Snapshot version that can be replayed for the current tenant. For system tenants and Meta tenants, this column is meaningless and displays as NULL
NoteThis column is available starting with V4.1.0. |
| READABLE_SCN | NUMBER | NO | Snapshot version that can be read for the current tenant. For system tenants and Meta tenants, this column is meaningless and displays as NULL
NoteThis column is available starting with V4.1.0. |
| RECOVERY_UNTIL_SCN | NUMBER | NO | Maximum recovery point for the current tenant. For system tenants and Meta tenants, this column is meaningless and displays as NULL
NoteThis column is available starting with V4.1.0. |
| LOG_MODE | VARCHAR2(100) | NO | Archiving mode:
NoteThis column is available starting with V4.1.0. |
| ARBITRATION_SERVICE_STATUS | VARCHAR2(64) | NO | Arbitration service status of the tenant. Valid values:
NoteThis column is available starting with V4.1.0. |
| UNIT_NUM | NUMBER(38) | NO | Minimum value of UNIT_NUM in each zone of the tenant
Note
|
| ZONE_UNIT_NUM_LIST | VARCHAR2(32767) | NO | This column displays 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 largest log stream ID that has ever existed in the tenant. For the system tenant and 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 been truncated. After a failover, you can execute an operation command to truncate the log stream of the original primary tenant to the specified point and then add the standby tenant of the original primary tenant to the new primary tenant.
NoteThis column is available starting with V4.4.1. |
| COMMENT | VARCHAR2(4096) | NO | The comment. |
Sample query
A user tenant queries the information about its own 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: 07-JAN-26 03.07.39.123961 PM
MODIFY_TIME: 07-JAN-26 03.07.45.487566 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: 1768208463899406000
REPLAYABLE_SCN: 1768208463899406000
READABLE_SCN: 1768208463799375000
RECOVERY_UNTIL_SCN: 4611686018427387903
LOG_MODE: NOARCHIVELOG
ARBITRATION_SERVICE_STATUS: DISABLED
UNIT_NUM: 1
ZONE_UNIT_NUM_LIST: zone1:1
COMPATIBLE: 4.4.2.0
MAX_LS_ID: 1001
RESTORE_DATA_MODE: NORMAL
FLASHBACK_LOG_SCN: NULL
COMMENT: NULL
1 row in set