Hai guys,

Is there any general recommendation for allocating SGA ?? Suppose if I have a DB which is 40% OLTP and 60% DSS, ie. Hybrid DB and 1GB of RAM, which also has java procedures in it, how much space i can allocate for SGA. Is there any proposition between SGA & RAM, i.e. some people say 30% of RAM can be allocated to SGA initially, is that true??