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