Re: How to reduce memory consumption?

From: Charles Hooper <>
Date: Sat, 22 Mar 2008 09:23:59 -0700 (PDT)
Message-ID: <>

On Mar 22, 11:13 am, Mladen Gogala <> 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:
> 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.
> --

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

Original text of this message