Well, from some statistics that an average process being invoked by
users consume 5Mb memory, and i read somewhere that it can be 1/4 of the physical memory. Then adjust it accordingly as no. of users increases.
Last edited by yxez; 09-19-2006 at 05:19 AM.
Behind The Success And Failure Of A Man Is A Woman
There is no perfect rule in allocating memory for SGA, PGA, etc; and it varies system to system.
You need to monitor the processes, collect statistics over period of time, and adjust the memory requirements accordingly.