Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
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
Feedback

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)   Short name for the service
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