SELECT
  inst_id,                                 -- INST_ID NUMBER
  name,                                    -- NAME VARCHAR2(64)
  value                                    -- VALUE VARCHAR2(512)
FROM
  gv$diag_info
WHERE
  inst_id = USERENV('INSTANCE')