Re: Sizing of SGA

From: Daniel Ady Surya <Daniel.Surya_at_mincom.co.id>
Date: Wed, 14 Apr 1999 11:58:08 +0700
Message-ID: <37141f3c@news1.us.ibm.net>

Hi....
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) Received on Tue Apr 13 1999 - 23:58:08 CDT