Re: Query does not work in RAC

From: Tim Gorman <tim_at_evdbt.com>
Date: Sun, 14 Apr 2013 13:03:28 -0600
Message-ID: <516AFD80.9060208_at_evdbt.com>

It might be helpful to post a prettified form of the SQL. It generally isn't necessary to include too much of the SELECT clause, but the FROM, WHERE, GROUP BY, ORDER BY, etc clauses all pertain to the execution plan.

If you know how to use the PL/SQL package DBMS_XPLAN, then it would also be an excellent idea to post the observed execution plans along with the prettified SQL text, rather than just trying to describe them to us.

If you don't know how to use DBMS_XPLAN, then please google it or just look at posts like
"http://www.oracle-base.com/articles/9i/dbms_xplan.php" or "http://jonathanlewis.wordpress.com/category/oracle/dbms_xplan/".

As Hans and John have politely been asking, provide the information to help us help you.

On 4/14/2013 12:39 PM, John Hurley wrote:
> Ahh ... well perhaps you should just ask the DBA for a bigger TEMP space allocation than 50 gb?
>
> Seriously you need to understand the data that is involved in the query ... and the SQL ... it is pretty unusual to have something chew up that much temp space without missing join conditions.
>
> As far as "when to force a hint" in SQL ... well the current thinking is "hardly ever".
>
> Current thinking is that one ONLY forces a hint under very carefully considered circumstances.
>
>
> --
> http://www.freelists.org/webpage/oracle-l

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

Received on Sun Apr 14 2013 - 21:03:28 CEST