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

On Sun, 14 Sep 2014 04:26:26 -0700, vsevolod afanassiev wrote:

> 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.

Vsebvolod, that depends on what those 200 users will be doing. If they will be running big batches, as you indicated, that means full table scans and direct reads into PGA. I wouldn't go overboard with SGA. I would start in single digits, with 8GB or so.

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com