Select Value
from v$parameter where name='service_names'

VALUE
---------------
service1, service2, service3, service4

SQL> Select service_name From v$session where sid=1980;

SERVICE_NAME
----------------------------------------------------------------
service1