SELECT
  group_id,                                -- GROUP_ID NUMBER
  name,                                    -- NAME VARCHAR2(64)
  interval_size,                           -- INTERVAL_SIZE NUMBER
  max_interval                             -- MAX_INTERVAL NUMBER
FROM
  gv$metricgroup
WHERE
  inst_id = USERENV('INSTANCE')