Re: Query does not work in RAC

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Sun, 14 Apr 2013 11:39:57 -0700 (PDT)
Message-ID: <1365964797.77295.YahooMailClassic_at_web181203.mail.ne1.yahoo.com>



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.

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Apr 14 2013 - 20:39:57 CEST

Original text of this message