Hidden parameter

EXEM Knowledge Base

Jump to: navigation, 찾기

Oracle에서 Hidden Parameter를 조회하는 쿼리는 다음과 같다.

connect "/as sysdba"

select ksppinm name,
      ksppstvl value,
      decode(bitand(ksppiflg/256,1),1,'true','false') ses_modifiable,
      decode(bitand(ksppiflg/65536,3),1,'immediate',2,'deferred',3,'immediate','false') sys_modifiable,
      ksppdesc description
from sys.x$ksppi i, sys.x$ksppcv v
where i.indx = v.indx
and i.ksppinm like '%&1%';