Oracle on AIX: how much memory to give to Oracle?
From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Sat, 13 Sep 2014 16:07:56 -0700 (PDT)
Message-ID: <ae7f4d07-4680-49c2-a2b1-c21a8da79337_at_googlegroups.com>
AIX 6.1 LPAR with 64 GB memory, no Active Memory Sharing Oracle 11.2.0.3, one instance used for batch processing Number of connections (Oracle sessions): less than 200 There is nothing else on this LPAR, only Oracle (single instance/no RAC)
Date: Sat, 13 Sep 2014 16:07:56 -0700 (PDT)
Message-ID: <ae7f4d07-4680-49c2-a2b1-c21a8da79337_at_googlegroups.com>
AIX 6.1 LPAR with 64 GB memory, no Active Memory Sharing Oracle 11.2.0.3, one instance used for batch processing Number of connections (Oracle sessions): less than 200 There is nothing else on this LPAR, only Oracle (single instance/no RAC)
Question: how would you set MEMORY_TARGET/MEMORY_MAX_TARGET to maximize amount of memory given to Oracle and at the same time to avoid running out of memory/swap? Received on Sun Sep 14 2014 - 01:07:56 CEST