make 10g Optimizer simular to 9i
*._optim_peek_user_binds=FALSE*._optimizer_cost_model='IO'[@more@]
10gR2 when enable > 36G SGA_TARGET
*._ksmg_granule_size=33554432[@more@]
solarisy 10 /etc/system
Instead of modify /etc/project as Oracle suggested. Following parameter has to be added to /etc/system for some reason so that the crs can start a very large SGA instance (in addition to set noexec_user_stack=1), for exampleset shmsys:shminfo_shmmax=206158430208[@more@]