Note
- This view is available starting with V4.3.3 in V4.3.x.
- This view is available starting with V4.2.4 in V4.2.x.
Purpose
The CDB_OB_SERVICES view displays information about all SERVICE_NAME values in all tenants.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. This column contains the IDs of user tenants. |
| 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 updated. |
| SERVICE_NAME_ID | bigint(20) | NO | The service name ID, which uniquely identifies the service name. |
| SERVICE_NAME | varchar(64) | NO | The service name. |
| SERVICE_STATUS | varchar(64) | NO | The service status. Valid values:
|
Sample query
Query information about all SERVICE_NAME values in all tenants.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_SERVICES;
The query result is as follows:
+-----------+----------------------------+----------------------------+-----------------+------------------+----------------+
| 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
References
- Query information about all
SERVICE_NAMEvalues in the current tenant: DBA_OB_SERVICES - For information about how to manage services, see Manage services.