Re: PGA_AGGREGATE_TARGET sizing of work areas and HJ cost

From: <>
Date: Fri, 29 May 2009 09:18:26 -0700 (PDT)
Message-ID: <>

On May 29, 12:14 pm, Grzegorz <> wrote:
> Hi,
>         I'm doing some investigations
> because of query plan changing in the same session (from NL Index RS to
> HJ FTS), and got question about Hash_Join_Area_Size when
> work_area_policy=auto.
> Is that possible that the same session can have different
> HJAS for same query ?
> When auto pga allocation is in place its quite possible in my opinion.
> Looks like depending on instance workload (in PGA terms) some queries
> may switch between NL Index RS and HJ FTS in the same session.
> I'm on .
> Regards.
> GG

Are you using bind variables? Received on Fri May 29 2009 - 11:18:26 CDT

Original text of this message