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)
  BLOCKED,                                 -- BLOCKED VARCHAR2(3)
  AQ_HA_NOTIFICATION,                      -- AQ_HA_NOTIFICATION VARCHAR2(3)
  CLB_GOAL                                 -- CLB_GOAL VARCHAR2(5)
from
  GV$ACTIVE_SERVICES
where
  inst_id = USERENV('Instance')