--- It will show all the registered services for the database.
col NETWORK_NAME for a25
set pagesize 299
set lines 299
select NAME,INST_ID,NETWORK_NAME,CREATION_DATE,GOAL,GLOBAL from GV$ACTIVE_SERVICES where name not like 'SYS$%';