Re: hash join extremely slow
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: ganstadba@xxxxxxxxxxx
- Date: Mon, 18 Dec 2006 21:12:50 +0100
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@xxxxxxxxxxx> wrote:
I would guess it's writing out to disk. What does v$sort_usage show?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
