Thursday, November 10, 2011

Getting the value of hidden parameters

for example the value of _smm_max_size

select a.ksppinm name, b.ksppstvl value, a.ksppdesc description
from sys.x$ksppi a, sys.x$ksppcv b
where a.indx = b.indx
and a.ksppinm = '_smm_max_size';

No comments: