Re: Query does not work in RAC
- From: John Hurley <hurleyjohnb@xxxxxxxxx>
- To: fuzzy.graybeard@xxxxxxxxx, ecandrietta@xxxxxxxxx
- Date: Sun, 14 Apr 2013 11:39:57 -0700 (PDT)
Ahh ... well perhaps you should just ask the DBA for a bigger TEMP space
allocation than 50 gb?
Seriously you need to understand the data that is involved in the query ... and
the SQL ... it is pretty unusual to have something chew up that much temp space
without missing join conditions.
As far as "when to force a hint" in SQL ... well the current thinking is
"hardly ever".
Current thinking is that one ONLY forces a hint under very carefully considered
circumstances.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
