Note
- For OceanBase Database V4.3.x, this view was introduced in OceanBase Database V4.3.3.
- For OceanBase Database V4.2.x, this view was introduced in OceanBase Database V4.2.4.
Purpose
The oceanbase.CDB_OB_SERVICES view displays all service names in all tenants.
Columns
Column |
Type |
Nullable? |
Description |
|
|---|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant, which can be a user tenant. | |
| CREATE_TIME | timestamp(6) | NO | The time when the service was created. | |
| MODIFIED_TIME | timestamp(6) | NO | The time when the service information was last modified. | |
| SERVICE_NAME_ID | bigint(20) | NO | The ID of the service, which uniquely identifies the name of the service. | |
| SERVICE_NAME | varchar(64) | NO | The name of the service. |
| SERVICE_STATUS | varchar(64) | NO | The status of the service. Valid values:
STARTED: The service has been started.STOPPING: The service is being stopped.STOPPED: The service has been stopped.
Sample query
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_SERVICES;
+-----------+----------------------------+----------------------------+-----------------+------------------+----------------+
| TENANT_ID | CREATE_TIME | MODIFIED_TIME | SERVICE_NAME_ID | SERVICE_NAME | SERVICE_STATUS |
+-----------+----------------------------+----------------------------+-----------------+------------------+----------------+
| 1002 | 2024-06-18 14:18:36.405999 | 2024-06-18 14:18:36.405999 | 3 | service_mysql001 | STARTED |
+-----------+----------------------------+----------------------------+-----------------+------------------+----------------+
1 row in set
+-----------+----------------------------+----------------------------+-----------------+------------------+----------------+
| TENANT_ID | CREATE_TIME | MODIFIED_TIME | SERVICE_NAME_ID | SERVICE_NAME | SERVICE_STATUS |
+-----------+----------------------------+----------------------------+-----------------+------------------+----------------+