Query does not work in RAC

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sun, 14 Apr 2013 05:23:30 -0300
Message-ID: <CAJdDhaMaToV4xNepHA0LnQeuazmJxQdTshtR4vPxFR=QU1XVvw_at_mail.gmail.com>

Hi,
I have a query that does not run in RAC environment. It uses a "lot of' TEMP tablespace.

I got sucess running it in the single instance.

The hint used is:
  SELECT /*+ USE_HASH(table1, table2) */

...

Basics parameters and statistics are Ok, It was got with sucess.

Any experience with this situation?
Any special parameter causes issue ?

Regards
Eriovaldo

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

Received on Sun Apr 14 2013 - 10:23:30 CEST