V$ACTIVE_SERVICES displays the active services in the database.
Name of the service
Hash of the service name
Creation date hash
Service workload management goal:
DTP flag for services (Y) or (N)
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.
Indicates whether AQ notifications are sent for HA events (YES) or not (NO)
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).