Find active services in db - Oracle Database Script. --- 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$%';
--- 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$%';