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`