Re: How to reduce memory consumption?

On Mar 22, 11:13 am, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> On Fri, 21 Mar 2008 11:39:02 -0700, Charles Hooper wrote:
> > The parameters SGA_TARGET and PGA_AGGREGATE_TARGET help control the
> > amount of memory used by Oracle - what values are specified for those
> > parameters?  If you are able to connect to the database using SQL*Plus,
> > type the following:
> > SHOW PARAMETER SGA_TARGET
> > SHOW PARAMETER PGA_AGGREGATE_TARGET
>
> Charles, he's using Oracle11g. Memory management mechanism has been
> significantly altered in oracle11. The new feature is described in the
> note 443746.1 about the automatic memory management. Having said that,
> I fully support your recommendation for checking the documentation.
>
> --http://mgogala.freehostia.com

Mladen, thanks for the reply. That looks like a very helpful Metalink note. Per the Metalink article, Oracle now offers 5 memory management methods... and I may have used the wrong buzz word to describe the method that uses SGA_TARGET and PGA_AGGREGATE_TARGET. I guess that I need to dig back into the Concepts manual for 11g to see what else is new.

One of the interesting items mentioned in the Metalink article is the following: "The preceding steps instruct you to set SGA_TARGET and PGA_AGGREGATE_TARGET to zero so that the sizes of the SGA and instance PGA are tuned up and down as required, without restrictions." That seems to raise the question, does setting a value for SGA_TARGET and PGA_AGGREGATE_TARGET help limit the memory used for the SGA and PGA when MEMORY_MAX_TARGET/MEMORY_TARGET is set? And is the limit specified as the minimum or maximum value? Now I have a reason to dig back into the Concepts manual.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Sat Mar 22 2008 - 11:23:59 CDT