Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-08
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
PDF · Mobi · ePub

V$SERVICES

V$SERVICES displays information about the services in the database.

Column Datatype Description
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)
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:
  • LONG

  • SHORT