Re: Query does not work in RAC
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Sun, 14 Apr 2013 08:41:32 -0600
Message-ID: <516AC01C.7000803_at_gmail.com>
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.)
Date: Sun, 14 Apr 2013 08:41:32 -0600
Message-ID: <516AC01C.7000803_at_gmail.com>
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.)
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Apr 14 2013 - 16:41:32 CEST