SERVICE_ID |
NUMBER |
|
Unique ID for the service |
NAME |
VARCHAR2(64) |
|
Service name for a queue |
NAME_HASH |
NUMBER |
|
Hash of the short name for the service |
NETWORK_NAME |
VARCHAR2(512) |
|
Network name used to connect to the service |
CREATION_DATE |
DATE |
|
Date the service was created |
CREATION_DATE_HASH |
NUMBER |
|
Hash of the creation date |
FAILOVER_METHOD |
VARCHAR2(64) |
|
Failover method (BASIC or NONE) for the service |
FAILOVER_TYPE |
VARCHAR2(64) |
|
Failover type (SESSION or SELECT) for the service |
FAILOVER_RETRIES |
NUMBER(10) |
|
Number of retries when failing over the service |
FAILOVER_DELAY |
NUMBER(10) |
|
Delay between retries when failing over the service |
MIN_CARDINALITY |
NUMBER |
|
Minimum cardinality of this service to be maintained by the director |
MAX_CARDINALITY |
NUMBER |
|
Maximum cardinality of this service to be allowed by the director |
GOAL |
VARCHAR2(12) |
|
Service workload management goal:
-
NONE
-
SERVICE_TIME
-
THROUGHPUT
|
DTP |
VARCHAR2(1) |
|
DTP flag for services (Y) or (N) |
ENABLED |
VARCHAR2(3) |
|
Indicates whether this service will be started/maintained by the director (YES) or not (NO) |
AQ_HA_NOTIFICATIONS |
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). |
