V$SERVICES
displays the 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 |
NUMBER |
Service workload management goal:
|
DTP |
VARCHAR2(1) |
DTP flag for services (Y) or (N) |
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, short being the default |