DBA_HIST_SERVICE_NAME displays the names of the Services tracked by the Workload Repository. This view contains information for V$SERVICES.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
DBID | 
NUMBER | 
NOT NULL | 
Database ID for the snapshot | 
SERVICE_NAME_HASH | 
NUMBER | 
NOT NULL | 
Hash of the service name | 
SERVICE_NAME | 
VARCHAR2(64) | 
NOT NULL | 
Name of the service |