Query does not work in RAC
- From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 14 Apr 2013 05:23:30 -0300
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
