SELECT
  INDX,                                    -- INDX NUMBER
  NAME,                                    -- NAME VARCHAR2(30)
  PID                                      -- PID NUMBER
FROM
  gv$process_group
WHERE
  INST_ID = USERENV('INSTANCE')