Originally posted by ganga
What SGA size can be set for my new OLTP database?
Database size going to be 100gb.RAM-4GB ,4-processor ,oracle- 8.1.7 on sun solaris- 8 with SUN Hardware
You can not give a direct answer to this question. How much PL/SQL code will the application use? The shared pool size depends on that. If this is the only DB running on that Solaris box you may start with using 60-70% of the RAM for thr SGA. Use large pool if SQL statements use parallel slaves or you backup with RMAN to tape.