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

On Monday, September 15, 2014 11:59:49 AM UTC-4, joel garry wrote:
> On Sunday, September 14, 2014 6:26:58 AM UTC-7, Mladen Gogala wrote:
>
> > On Sun, 14 Sep 2014 04:26:26 -0700, vsevolod afanassiev wrote:
>
>
> > > 9.2 on AIX 5.3, what should be setting for sga_max_size if LPAR memory
>
>
> >
>
> > 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.
>
> >
>
> Not sure how many direct reads into the PGA would happen in 9.2.
>
> >
>
>
> jg
>
> --
>
> _at_home.com is bogus.
>
> http://www.zdnet.com/oracle-acquires-media-storage-company-front-porch-digital-7000033639/

Even so with only 200 concurrent sessions 8G is likely more than adequate to support the database applications with decent performance. We have systems that support a higher load with smaller SGA's that this.

HTH -- Mark D Powell -- Received on Tue Sep 16 2014 - 17:48:28 CEST