Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
The oceanbase.DBA_OB_ZONES view displays the information about all zones.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| ZONE | varchar(128) | NO | The name of the zone. |
| CREATE_TIME | timestamp(6) | NO | The time when the zone was created. |
| MODIFY_TIME | timestamp(6) | NO | The time when the zone was modified. |
| STATUS | varchar(4096) | NO | The status of the zone. Valid values: ACTIVE: The zone is active and provides services normally.INACTIVE: The zone is stopped. |
| IDC | varchar(4096) | NO | The IDC to which the zone belongs. |
| REGION | varchar(4096) | NO | The region where the zone belongs. |
| TYPE | varchar(4096) | NO | The type of the zone. Valid values: ReadWrite: read/write zoneEncryption: encrypted zone |
Sample query
Query all zone information in the cluster in the sys tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_ZONES;
The query result is as follows:
+-------+----------------------------+----------------------------+--------+------+---------+-----------+
| ZONE | CREATE_TIME | MODIFY_TIME | STATUS | IDC | REGION | TYPE |
+-------+----------------------------+----------------------------+--------+------+---------+-----------+
| zone1 | 2025-01-06 16:31:31.733840 | 2025-01-07 13:53:45.645465 | ACTIVE | | region1 | ReadWrite |
+-------+----------------------------+----------------------------+--------+------+---------+-----------+
1 row in set