Oracle 查看有那些隐藏的初始化参数

set linesize 128
column name format a42
col SESMOD  for a10                         
col SYSMOD for a10

select
  x.ksppinm  name,
  decode(bitand(ksppiflg/256,1),1,'TRUE','FALSE')  sesmod,
  decode(
    bitand(ksppiflg/65536,3),
    1,'IMMEDIATE',
    2,'DEFERRED',
    3,'IMMEDIATE',
    'FALSE'
  )  sysmod,
  ksppdesc  description
from
  sys.x_$ksppi  x
where
  x.inst_id = userenv('Instance') and
  translate(ksppinm,'_','#') like '#%'
order by
  1
/
-----------------------------------------------------------
--查看参数的值
set linesize 132

column name