Hi Subodh, thanks but the last 2 links are on ASSM whereas I was talking about ASMM i.e. Automatic Shared Memory Management. regards On Thu, May 17, 2012 at 9:49 PM, Subodh Deshpande < deshpande.subodh@xxxxxxxxx> wrote: > what sga size you gave for new instance while installing > > here are some few links, about ASSM there are various opinions I think.. > > https://forums.oracle.com/forums/thread.jspa?threadID=695072 > > > http://hemantoracledba.blogspot.in/2008/08/assm-or-mssm-impact-on-inserts.html > > http://www.dba-oracle.com/art_builder_assm.htm > > > -- //www.freelists.org/webpage/oracle-l