Re: How much memory Target needed ?

From: Seth Miller <>
Date: Mon, 29 Dec 2014 14:56:57 -0600
Message-ID: <>


If you are going to use AMM, you will set memory_target to roughly the sum of your current SGA and PGA. However, if you have memory to spare, you may want to set it a little higher and keep an eye on the memory advisor to see if it needs adjustment.

If you are not sure what to set a parameter to, leave it as the default and adjust it as needed.

Seth Miller

On Mon, Dec 22, 2014 at 2:01 AM, walid kaakati <> wrote:

> Hi list,
> I have two questions :
> 1- We are about to migrate from oracle 10g to Oracle 11g (11.2.2),
> currently i have 4000MB for SGA and 2200MB for PGA , we bought new server
> with 64GB RAM iam wondering how much i need to put for memory_target as a
> start since i want to use AMM.
> I have: windows server 2008R2 ,Shared server configuration,450
> sessions,OlTP database with size 40GB .
> 2- Which parameters other than session,processes,shared server i need to
> adjust ?
> Best wishes for all you

Received on Mon Dec 29 2014 - 21:56:57 CET

Original text of this message