select
  service_name,                            -- SERVICE_NAME VARCHAR2(64)
  service_name_hash,                       -- SERVICE_NAME_HASH NUMBER
  event,                                   -- EVENT VARCHAR2(64)
  event_id,                                -- EVENT_ID NUMBER
  total_waits,                             -- TOTAL_WAITS NUMBER
  total_timeouts,                          -- TOTAL_TIMEOUTS NUMBER
  time_waited,                             -- TIME_WAITED NUMBER
  average_wait,                            -- AVERAGE_WAIT NUMBER
  max_wait,                                -- MAX_WAIT NUMBER
  time_waited_micro                        -- TIME_WAITED_MICRO NUMBER
from
  gv$service_event
where
  inst_id = USERENV('Instance')