Re: PGA_AGGREGATE_TARGET sizing of work areas and HJ cost

From: <johnbhurley_at_sbcglobal.net>
Date: Fri, 29 May 2009 09:18:26 -0700 (PDT)
Message-ID: <4bf51e6c-63d7-4e30-b9f8-963bd6e22a7d_at_z19g2000vbz.googlegroups.com>



On May 29, 12:14 pm, Grzegorz <fgrzegor..._at_finteria.pl> 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 9.2.0.8 .
> Regards.
> GG

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

Original text of this message