Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_SERVICES

ALL_SERVICES displays all services in the database. The view excludes rows marked for deletion.

Related View

DBA_SERVICES displays all services in the database. The view excludes rows marked for deletion.

Column Datatype NULL Description
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).