Re: Oracle 10g: SQL Statements KEPT in the Shared Pool

About the value of the parameter for me is true, why is false in your
instance, I didn't change it?
Oracle 10.2.0.2.0

select
       nam.indx+1                            numb,
       nam.ksppinm                           name,
       val.ksppstvl                          value,
       nam.ksppity                           type,
       val.ksppstdf                          is_default,
       decode(bitand(nam.ksppiflg/256,1),
              1,'True',
                'False'
       )                                     is_session_modifiable,
       decode(bitand(nam.ksppiflg/65536,3),
              1,'Immediate',
              2,'Deferred' ,
              3,'Immediate',
                'False'
       )                                     is_system_modifiable,
       decode(bitand(val.ksppstvf,7),
              1,'Modified',
              4,'System Modified',
                'False'
       )                                     is_modified,
       decode(bitand(val.ksppstvf,2),
              2,'True',
                'False'
       )                                     is_adjusted,
       nam.ksppdesc                          description
from
       x$ksppi        nam,
       x$ksppsv       val
where
       nam.indx = val.indx
       and nam.ksppinm = '_kks_use_mutex_pin'
;

Other related posts: