Re: PGA_AGGREGATE_TARGET sizing of work areas and HJ cost

From: Jonathan Lewis <>
Date: Fri, 29 May 2009 21:24:18 +0100
Message-ID: <>

"joel garry" <> wrote in message On May 29, 10:45 am, "Jonathan Lewis" <> wrote:

>> Joel,
>> From the way the OP asks the question I don't think he had the
>> parameter hash_area_size in mind; to me it sounded like a
>> question about "how is the equivalent of the hash_area_size
>> derived when using automatic workarea sizing".
>From his reply to John, that's even less clear to me. I have no
>problem with myself or anyone misreading any of this, I think it is a
>good thing that people are willing to fill in the blanks.
> ...

You're right - my interpretation was wrong. Apologies for muddying the waters.


Jonathan Lewis

Author: Cost Based Oracle: Fundamentals

The Co-operative Oracle Users' FAQ
Received on Fri May 29 2009 - 15:24:18 CDT

Original text of this message