Oracle – Display Hidden Initialization Parameters

Hidden Oracle Initialization Parameters

To display hidden Oracle initialization parameters:

select 
  ksppinm,
  ksppstvl 
from 
  x$ksppi a, 
  x$ksppsv b 
where 
  a.indx=b.indx and 
  substr(ksppinm,1,1) = '_';
select 
  ksppinm,
  ksppstvl 
from 
  x$ksppi a, 
  x$ksppsv b 
where 
  a.indx=b.indx and 
  substr(ksppinm,1,1) = '_';

Leave a Reply

Your email address will not be published. Required fields are marked *