Re: Oracle on AIX: how much memory to give to Oracle?

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Sun, 14 Sep 2014 04:26:26 -0700 (PDT)
Message-ID: <afc888d1-2e66-42ce-82ee-01b07757ae8e_at_googlegroups.com>

Thanks for responding
My question wasn't about AMM, my question was about amount of memory we should allocate to Oracle. Let's say this is 9.2 on AIX 5.3, what should be setting for sga_max_size if LPAR memory is 64GB, number of connections never exceeds 200, and PGA utilization never exceeds 5 GB? 32 GB looks too low, may be 48 GB? 56 GB? AIX doesn't really need much memory, we have smaller LPARs happily running with 4 GB memory.

Yes, I would definitely set FILESYSTEMIO_OPTIONS to SETALL in order to enable direct reads and asynchronous reads.

What should I use instead of Google groups? OTN (Oracle Technology Network Community)? It gave me username "user10490308" and I was unable to change it. Received on Sun Sep 14 2014 - 13:26:26 CEST

This message: [ Message body ]
Next message: Mladen Gogala: "Re: Another newsgroup gone - may they rest in peace."
Previous message: vsevolod afanassiev: "Oracle on AIX: how much memory to give to Oracle?"
Maybe in reply to: vsevolod afanassiev: "Oracle on AIX: how much memory to give to Oracle?"
Next in thread: Mladen Gogala: "Re: Oracle on AIX: how much memory to give to Oracle?"
Reply: Mladen Gogala: "Re: Oracle on AIX: how much memory to give to Oracle?"
Reply: joel garry: "Re: Oracle on AIX: how much memory to give to Oracle?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message