Hidden Parameter

How to Check Hidden Parameters in Oracle

CAUTION: Please don't try to make changes in these Parameters until Recommended by Oracle

Hidden parameters that always start with an underscore can be found in x$ksppi, along with a description:

select 

  ksppinm,

  ksppdesc 

from 

  x$ksppi

where 

  substr(ksppinm,1,1) = '_';

If we want to query the value of such a hidden parameter, we have to join the table with x$ksppsv and select its ksppstvl attribute:

  select 

    ksppinm,

    ksppstvl 

  from 

    x$ksppi a, 

    x$ksppsv b 

  where 

    a.indx=b.indx and 

  substr(ksppinm,1,1) = '_';

=============

Another Easy Way in 11g

Create pfile as under

cd $ORACLE_HOME/dbs

sqlplus /as sysdba

create pfile from memory;

exit

view init.ora

it will show you all the parameter available in DB