Find Out Oracle Hidden Parameters

<<Back to DB Administration Main Page

How to Find Out Oracle Hidden Parameters

You can find out all the hidden parameter using below query

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

Example:

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

KSPPINM                        KSPPSTVL                       KSPPDESC
------------------------------ ------------------------------ ----------------------------------------
_db_block_hash_buckets         131072                         Number of database block hash buckets

Parameter _db_block_hash_buckets used to control  Number of database block hash buckets current value is 131072