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
This view DBA_OB_SERVICES displays information about all SERVICE_NAME in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| CREATE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The creation time of the service. |
| MODIFIED_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The update time of the service information. |
| SERVICE_NAME_ID | NUMBER(38) | NO | The ID of the service name, used to uniquely identify the service name. |
| SERVICE_NAME | VARCHAR2(64) | NO | The service name. |
| SERVICE_STATUS | VARCHAR2(64) | NO | The status of the service. Valid values:
|
Sample query
Query information about all SERVICE_NAME in the current tenant.
obclient [SYS]> SELECT * FROM SYS.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_oracle001 | STARTED |
+----------------------------+----------------------------+-----------------+------------------+----------------+
1 row in set
References
Query information about all
SERVICE_NAMEin all tenants: CDB_OB_SERVICESFor information about operations related to
SERVICE_NAME, see Manage services.