PGA_AGGREGATE_TARGET sizing of work areas and HJ cost
From: Grzegorz <fgrzegorzof_at_finteria.pl>
Date: Fri, 29 May 2009 18:14:31 +0200
Message-ID: <gvp1l6$jls$1_at_news.task.gda.pl>
Hi,
Date: Fri, 29 May 2009 18:14:31 +0200
Message-ID: <gvp1l6$jls$1_at_news.task.gda.pl>
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
Received on Fri May 29 2009 - 11:14:31 CDT