-
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 <g>
-
thank you pando for so much help
regards
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|