Re: How much memory Target needed ?

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 <dmarc-noreply_at_freelists.org> 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
>

--
http://www.freelists.org/webpage/oracle-l