What is proper size of SGA?

What is proper size of SGA?(f8)

What are the factors for sizing the SGA. Are there any fixed rules like for a system with 50 users, OLTP system and 100 GB database. The question I want to ask is, are there any formulae which can be used to determine the size the SGA beforehand.

Ans:

There are several parameters that effect the SGA size such as:
db_block_buffers and shared_pool_size.
These parameters are related to performance tuning.
You can change these parameters if you have a problem with
the database performance. No formula for this SGA size but
you can estimate how memory required for your oracle database
and applications and then you can monitor database performance
using utlbstat.sql and utlestat.sql. Besides, you have to consider
about your sql statement and indexes.
If you want to know further, you can read any oracle books related
to performance tuning, oracle database architecture.

Regards,

Daniel
IT Consultant (DBA)

Hosted by www.Geocities.ws