select
  SID,                                     -- SID VARCHAR2(4000)
  NUM,                                     -- NUM NUMBER
  NAME,                                    -- NAME VARCHAR2(80)
  TYPE,                                    -- TYPE NUMBER
  DISPLAY_VALUE,                           -- DISPLAY_VALUE VARCHAR2(4000)
  ORDINAL,                                 -- ORDINAL NUMBER
  UPDATE_COMMENT                           -- UPDATE_COMMENT VARCHAR2(255)
from
  GV$SYSTEM_PARAMETER4
where
  INST_id = USERENV('Instance')