Johnson, I am curious to know the value for the parameter too _small_table_threshold

select ksppinm,ksppstvl,ksppstdf,
decode(bitand(ksppiflg/256,1),1,'TRUE' ,'FALSE'), decode(bitand(ksppiflg/65536,3),1,'IMMEDIATE',2,'DEFERRED',3,'IMMEDIATE','FALSE'),
decode(bitand(ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE'),
decode(bitand(ksppstvf,2),2,'TRUE','FALSE'), ksppdesc
from x$ksppi x, x$ksppcv y where (x.indx = y.indx) and KSPPINM ='_small_table_threshold' ;

Please run it and post the result in the same database.

Thomas