V$ACTIVE_SERVICES
displays the active services in the database.
Column | Datatype | Description |
---|---|---|
SERVICE_ID |
NUMBER |
Service ID |
NAME |
VARCHAR2(64) |
Name of the service |
NAME_HASH |
NUMBER |
Hash of the service name |
NETWORK_NAME |
VARCHAR2(512) |
Network name |
CREATION_DATE |
DATE |
Creation date |
CREATION_DATE_HASH |
NUMBER |
Creation date hash |
GOAL |
VARCHAR2(12) |
Service workload management goal:
|
DTP |
VARCHAR2(1) |
DTP flag for services (Y) or (N) |
BLOCKED |
VARCHAR2(3) |
States whether a service on the specified instance is blocked from accepting new connections altogether. If a service is BLOCKED , then all connections will be directed to other instances (if any) that are hosting the desired service. |
AQ_HA_NOTIFICATION |
VARCHAR2(3) |
Indicates whether AQ notifications are sent for HA events (YES) or not (NO) |
CLB_GOAL |
VARCHAR2(5) |
The connection load balancing goal. It is used with statistics that are sent to the listeners to determine how new connections are distributed. It may be set to either LONG or SHORT (the default). |