DBA_HIST_SERVICE_NAME

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