Re: Query does not work in RAC

My issue: during sql execution with USE_HASH hint , more than 50gb space were used and stopped execution giving error in tablespace.

I changed the hint to USE_MERGE instead of USE_HASH and it did not used temporary tablespace.

I think I need to change my question:

When we use the HINT USE_HASH , it uses temporary tablespace ? or it can be a bug ?

Regards
Eriovaldo

On Sun, Apr 14, 2013 at 11:41 AM, Hans Forbrich <fuzzy.graybeard_at_gmail.com>wrote:

> 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-l
>
>
>

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