SERVICE_ID |
NUMBER |
Service ID |
NAME |
VARCHAR2(64) |
Name of the service |
NAME_HASH |
NUMBER |
Service name hash |
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:
-
NONE
-
SERVICE_TIME
-
THROUGHPUT
|
DTP |
VARCHAR2(1) |
Indicates whether the service is for DTP or distributed transactions including XA transactions (Y) or not (N) |
BLOCKED |
VARCHAR2(3) |
Indicates whether a service on the specified instance is blocked from accepting new connections altogether (YES) or not (NO). 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) |
Connection load balancing goal used with statistics that are sent to the listeners to determine how new connections are distributed:
|
