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

E40402-12
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$ACTIVE_SERVICES

V$ACTIVE_SERVICES displays information about the active 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)
BLOCKED VARCHAR2(3) Indicates whether a service on the specified instance is blocked from accepting new connections altogether (YES) or not (NO). If a service is blocked, then all connections will be directed to other instances (if any) that are hosting the desired service.
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