select
  NAME,                                    -- NAME VARCHAR2(64)
  ISSPECIFIED                              -- ISSPECIFIED VARCHAR2(5)
from
  GV$OBSOLETE_PARAMETER
where
  inst_id = USERENV('Instance')