select x.inst_id, -- INST_ID NUMBER kspftctxsid, -- SID VARCHAR2(4000) kspftctxpn, -- NUM NUMBER ksppinm, -- NAME VARCHAR2(80) ksppity, -- TYPE NUMBER kspftctxdvl, -- DISPLAY_VALUE VARCHAR2(4000) kspftctxvn, -- ORDINAL NUMBER kspftctxct -- UPDATE_COMMENT VARCHAR2(255) from x$ksppi x, x$ksppsv2 y where ((x.indx+1) = kspftctxpn) and (bitand(ksppilrmflg,64)!=64) and ((kspftctxdf = 'FALSE') or (bitand(kspftctxvf,8) = 8))