Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!border3.nntp.aus1.giganews.com!nntp2.aus1.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsmm00.sul.t-online.com!t-online.de!news.t-online.com!not-for-mail
From: Rick Denoire <100.17706@germanynet.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: Use of TEMP tablespace other than sorting
Date: Tue, 04 Mar 2003 00:33:48 +0100
Organization: T-Online
Lines: 12
Message-ID: <0ro76vgr6p6qimjsagojp09k3rif0i4106@4ax.com>
References: <bdgq5vgo1m50r16l2a40ilp7u49hokcbam@4ax.com> <v5r184mp5mjgde@corp.supernews.com> <j36t5vcqtc14rrm8spiof4v93vijh0q6sd@4ax.com> <v660f8jlmv0q83@corp.supernews.com> <b3v77u$jmo$1$8300dec7@news.demon.co.uk>
Reply-To: 100.17706@germanynet.de
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.t-online.com 1046734397 05 27290 xsRmEaqGS+YJzV 030303 23:33:17
X-Complaints-To: abuse@t-online.com
X-ID: SIUKRgZ6reEkdDgn2G1LmbUGGUomg9Lo7S+NPZWWhWK+YYfdt9QvkS
X-Newsreader: Forte Agent 1.7/32.534
Xref: newsfeed1.easynews.com comp.databases.oracle.server:178327
X-Received-Date: Mon, 03 Mar 2003 16:34:01 MST (news.easynews.com)

"Jonathan Lewis" <jonathan@jlcomp.demon.co.uk> wrote:


>...(Apart from the fact that decreasing
>the hash_area_size MIGHT just be enough to push
>Oracle from doing a hash join to using a different
>join mechanism).

OK, I will diminish hash_area_size and see what happens.
Seems to be a kind of shortcut solution.

Rick Denoire