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

Note:

1.

select * from V$ACTIVE_SERVICES;

SERVICE_ID	NAME	NAM_ HASH	NETWORK_ NAME	CREATION_ DATE	CREATION_ DATE_ HASH	GOAL	DTP	BLOCKED	AQ_ HA_ NOTIFICATION	CLB_ GOAL
3	mydbXDB	1119650025	mydbXDB	2006-06-10 11:46:21 AM	168918946	NONE	N	NO	NO	LONG
4	mydb.env.gov.bc.ca	720991384	mydb.env.gov.bc.ca	2006-06-10 11:46:21 AM	168918946	NONE	N	NO	NO	LONG
1	SYS$BACKGROUND	165959219		2006-06-10 9:31:34 AM	0	NONE	N	NO	NO	SHORT
2	SYS$USERS	3427055676		2006-06-10 9:31:34 AM	18489460	NONE	N	NO	NO	SHORT

Oracle data dictionary views

Oracle dynamic performance views