Re: Oracle 10g: SQL Statements KEPT in the Shared Pool
- From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
- To: "Anand Rao" <panandrao@xxxxxxxxx>
- Date: Wed, 22 Nov 2006 09:03:27 -0400
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:
