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

Part Number B14237-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

V$SERVICES

V$SERVICES displays the 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 NUMBER Service workload management goal:
  • NONE

  • SERVICE_TIME

  • THROUGHPUT

DTP VARCHAR2(1) DTP flag for services (Y) or (N)
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, short being the default