Re: Query does not work in RAC
- From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 14 Apr 2013 08:41:32 -0600
On 14/04/2013 2:23 AM, Eriovaldo Andrietta wrote:
> 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) */
"Does not run" usually involves some sort of message. Please describe
your result - especially error message and diagnostic information
(trace, alert log) as well as a few interesting details about your
environment (OS, DB version, etc.)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
