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

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 15 Sep 2014 16:35:50 +0000 (UTC)
Message-ID: <lv74h5$67j$1_at_solani.org>


On Mon, 15 Sep 2014 08:59:49 -0700, joel garry wrote:

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

Oh, I missed that small detail. You say that direct reads into PGA during a full table scan haven't been been backported to 9i?

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com
Received on Mon Sep 15 2014 - 18:35:50 CEST

Original text of this message