Re: Query does not work in RAC
- From: Tim Gorman <tim@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 14 Apr 2013 13:03:28 -0600
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.
>
>
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
