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
Feedback

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

V$ACTIVE_SERVICES

V$ACTIVE_SERVICES displays the active 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 VARCHAR2(12) Service workload management goal:
  • NONE

  • SERVICE_TIME

  • THROUGHPUT

DTP VARCHAR2(1) DTP flag for services (Y) or (N)
BLOCKED VARCHAR2(3) States whether a service on the specified instance is blocked from accepting new connections altogether. 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) 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).