Re: Oracle on AIX: how much memory to give to Oracle?
From: joel garry <joel-garry_at_home.com>
Date: Mon, 15 Sep 2014 08:59:49 -0700 (PDT)
Message-ID: <b0b0bb3c-405b-4529-96e4-db0f729cdf70_at_googlegroups.com>
Date: Mon, 15 Sep 2014 08:59:49 -0700 (PDT)
Message-ID: <b0b0bb3c-405b-4529-96e4-db0f729cdf70_at_googlegroups.com>
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/Received on Mon Sep 15 2014 - 17:59:49 CEST