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
Printable View
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
if i remmeber rightly, the max SGA size on 8.1.7 is 1.75 Gb unless you relink your libraries with some flag.
So use 1.75 Gb :-)
On our we use about 100Mb for shared pool unless you have heaps and heaps of pl/sql code.
Do you use java, if so set your java pool
use majoirty on block buffers
This assumes one instance and having an app that doesnt require gobs of RAM
Hi,
"bigger is better"
But it is difficult to answer generally.
You can find the exact hint for resizing of memory on www.metalink.oracle.com.
Searching phrase :1028623.6
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.Quote:
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
This is some pretty old words.Quote:
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
New 64bit oracle has been support Terabyte sga on 64bit platform.
The proper sga size depends on the number of connections, ufs or raw, etc.