sort_area_size=1048576bytes
Printable View
sort_area_size=1048576bytes
decrease that value to 128K, what platform is this? 8i?
yes 8i,do u think I should include large pool size =20m in init.ora,which will increase the sga further and as memory error is there ???//
Well I dont think it´s related to SGA, it is related to PGA so leave SGA intact, if it was 4031 then it is SGA problem but it isnt.
hi, thanks for so fast reply,but whether to include largepool in init.ora or not .presently it is set to 0.and i am using mts.so should i increase large pool size or not.
Set large pool to 10M, if you get 4031 in the future increase it
thank you pando for so much help
regards