Suppose we need to find hidden parameter(_kks_use_mutex_pin) value in Database.
Execute Below Query:
SQL> select x.ksppinm name,y.ksppstvl value from
sys.x$ksppi x,sys.x$ksppcv y where
x.inst_id=sys_context('userenv', 'instance') and
y.inst_id=sys_context('userenv', 'instance') and
x.indx=y.indx AND
x.ksppinm = '_kks_use_mutex_pin';
If it's having value false and you want to change it to true.
Do the below:
SQL> alter system set "_kks_use_mutex_pin"=false scope=spfile;
SQL> shutdown immediate
SQL> startup
