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

From: Mladen Gogala <>
Date: Mon, 15 Sep 2014 16:35:50 +0000 (UTC)
Message-ID: <lv74h5$67j$>

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
Received on Mon Sep 15 2014 - 18:35:50 CEST

Original text of this message