Re: Query does not work in RAC
Date: Mon, 15 Apr 2013 10:10:17 -0300
Message-ID: <CAJdDhaNDCkfzKQk6Y8YFSXoFGUhx33JG1qaLOqncjbPuShb+yA_at_mail.gmail.com>
Hi Hans,
Thanks a lot for your attention and others person.
1.) Here are the database version:
Oracle 11.2.0.1
64 bits
linux red hat
Red Hat Enterprise Linux Server release 5.5
2.) When I said: the SQL stopped.
It caused error: ORA-01652: não é possível estender o segmento temp.
em 128 no tablespace TEMP
ORA-06512
But I would like to say that the issue is solved.
For me, all new resources and care will be util to next needs, new
projects and new situations like that.
Thanks
Eriovaldo
On Mon, Apr 15, 2013 at 7:08 AM, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk
> wrote:
>
> A particularly relevant side effect here is that a plan that uses a merge
> join rather than a hash join could have produced the results in a different
> order (even when joining the tables in the same order), and that could have
> a significant impact on the clustering_factors of the indexes created on
> the data, which could result in unexpected choice of indexes and surprising
> execution plans later on in the life of the application.
>
>
>
> Regards
> Jonathan Lewis
>
> ________________________________________
> From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on
> behalf of Hans Forbrich [fuzzy.graybeard_at_gmail.com]
> Sent: 15 April 2013 02:55
> To: oracle-l_at_freelists.org
> Subject: Re: Query does not work in RAC
>
> > In my case, the SQL should run only once, and I just changed the USE_HASH
> > to USE_MERGE and solved my problem ...
> Lucky. But do you know WHY? And whether this will impact anything in
> the future? Or will this lead to another hit-and-miss myth?--
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 15 2013 - 15:10:17 CEST