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: Michael McMullen <ganstadba_at_hotmail.com>
Date: Mon, 18 Dec 2006 11:31:15 -0500
Message-ID: <BAY103-DAV1975FDF87B53E7AAAC240A6C90@phx.gbl> 





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

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


Received on Mon Dec 18 2006 - 10:31:15 CST












Original text of this message













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