select
  INST_ID,                                 -- INST_ID NUMBER
  KSPSPFFTCTXSPSID,                        -- SID VARCHAR2(80)
  KSPSPFFTCTXSPNAME,                       -- NAME VARCHAR2(80)
  decode(                                  -- TYPE VARCHAR2(11)
    KSPSPFFTCTXPARTYP,1,'boolean',2,'string', 3,'integer', 4,'file',5,'number', 6,'big integer', 'unknown'),
  KSPSPFFTCTXSPVALUE,                      -- VALUE VARCHAR2(255)
  KSPSPFFTCTXSPDVALUE,                     -- DISPLAY_VALUE VARCHAR2(255)
  KSPSPFFTCTXISSPECIFIED,                  -- ISSPECIFIED VARCHAR2(6)
  KSPSPFFTCTXORDINAL,                      -- ORDINAL NUMBER
  KSPSPFFTCTXCOMMENT                       -- UPDATE_COMMENT VARCHAR2(255)
from
  x$kspspfile
WHERE
  ((translate(KSPSPFFTCTXSPNAME,'_','#') not like '##%') and ((translate(KSPSPFFTCTXSPNAME, '_', '#') not like '#%') OR KSPSPFFTCTXISSPECIFIED = 'TRUE'))