Overview
The DBA_OB_SERVICES view displays information about all SERVICE_NAME objects in the current tenant.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| CREATE_TIME | timestamp(6) | NO | The time when the service was created. |
| MODIFIED_TIME | timestamp(6) | NO | The update time of service-related information. |
| SERVICE_NAME_ID | bigint(20) | NO | Service name ID, which uniquely identifies the service name. |
| SERVICE_NAME | varchar(64) | NO | Service name. |
| SERVICE_STATUS | varchar(64) | NO | Service status. Valid values:
|
Sample query
Query all information related to SERVICE_NAME in the current tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_SERVICES;
The query result is as follows:
+----------------------------+----------------------------+-----------------+------------------+----------------+
| CREATE_TIME | MODIFIED_TIME | SERVICE_NAME_ID | SERVICE_NAME | SERVICE_STATUS |
+----------------------------+----------------------------+-----------------+------------------+----------------+
| 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_NAMEinstances under all tenants: CDB_OB_SERVICESFor operations related to
SERVICE_NAME, see the Manage services topic.