GV$SYSTEM_PARAMETER4 definition in Oracle Database 11.2
GV$SYSTEM_PARAMETER4

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))

home |  up