select SERVICE_ID, -- SERVICE_ID NUMBER NAME, -- NAME VARCHAR2(64) NAME_HASH, -- NAME_HASH NUMBER NETWORK_NAME, -- NETWORK_NAME VARCHAR2(512) CREATION_DATE, -- CREATION_DATE DATE CREATION_DATE_HASH, -- CREATION_DATE_HASH NUMBER GOAL, -- GOAL VARCHAR2(12) DTP, -- DTP VARCHAR2(1) AQ_HA_NOTIFICATION, -- AQ_HA_NOTIFICATION VARCHAR2(3) CLB_GOAL -- CLB_GOAL VARCHAR2(5) from GV$SERVICES where inst_id = USERENV('Instance')