RE: performance question

From: Alvaro Jose Fernandez <alvaro.fernandez_at_sivsa.com>
Date: Mon, 10 Sep 2007 20:14:36 +0200
Message-ID: <607D6181D9919041BE792D70EF2AEC48242BD6@LIMENS.sivsa.int>

ah, I understand now.

Joan, one last question. Have you tried then to equal the PGA size on both?... (sorry this seems so stupid, but nopw I really cannot think of other explanation aside different temp area capacity for the hash)

regards.

>The id=27, on TRN it retuns 0 while it returns 31,967 rows on QA is
_understandable, cause on TRN it failed and it never reached that far.

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

Received on Mon Sep 10 2007 - 13:14:36 CDT