Re: How to set SGA size initially?

Here is what Oracle says -

One very difficult judgement that needs to be make in Oracle7/8.x is to determine

the proper size of the shared pool. The following provides some guidelines for this. It should be emphasized that these are just guidelines, there are no hard and fast rules here and experimentation will be needed to determine a good value.

The shared pool size is highly application dependent. To determine the shared pool size that will be needed for a production system it is generally necessary to first develop the application and run it on a test system and take some measurements. The test system should be run with a very large value for the shared pool size to make the measurements meaningful.

Ramamohan B N wrote:

> Hi,
>
> How do I select the size of SGA (DB Buffer & Shared pool size) during
> the database design? Are there any guidelines?
>
> Thanx & Regards,
> Ramamohan B N
> --
> Author: Ramamohan B N
> INET: ramamohan.bn_at_tatainfotech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jun 20 2000 - 07:06:40 CDT