Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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'
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 22 2006 - 07:03:27 CST
![]() |
![]() |