Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Use of TEMP tablespace other than sorting

Re: Use of TEMP tablespace other than sorting

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Tue, 04 Mar 2003 00:33:48 +0100
Message-ID: <0ro76vgr6p6qimjsagojp09k3rif0i4106@4ax.com> 





"Jonathan Lewis" <jonathan_at_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
Received on Mon Mar 03 2003 - 17:33:48 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US