SGA size for 100gb database?

[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

[davey23uk]

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

[ldanicsk]

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

[julian]

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.

[chao_ping]

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.
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.