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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: hash join extremely slow

Re: hash join extremely slow

From: LS Cheng <exriscer_at_gmail.com>
Date: Mon, 18 Dec 2006 21:12:50 +0100
Message-ID: <6e9345580612181212o755c0a50ra87c1de95bcfcc3b@mail.gmail.com> 





Hi



To my surprise it is not reading the temporary tablespace, it is doing db
file sequential read.



However my point is why almos 5 hours is needed to perform a 75789 block
hash join!



TIA



--
LSC



On 12/18/06, Michael McMullen <ganstadba_at_hotmail.com> wrote:


>

> I would guess it's writing out to disk. What does v$sort_usage show?

> --

> http://www.freelists.org/webpage/oracle-l

>

>

>


--
http://www.freelists.org/webpage/oracle-l


Received on Mon Dec 18 2006 - 14:12:50 CST












Original text of this message













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