RE: Query does not work in RAC

From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Sun, 14 Apr 2013 16:56:56 +0000
Message-ID: <DUB115-W20D1501888445E6EE453B8A1C30_at_phx.gbl>



Excessive temp space usage is usually linked to poor execution plan estimates. Poor estimates can lead to suboptimal execution plans and/or inappropriately sized workareas. Inappropriately sized workareas can result in excessive temp space usage. Use real time sql monitoring or dbms_xplan.display_cursor in conjunction with either statistics_level = all or gather_plan_statstics hint to see if there is an issue with significantly inaccurate estimates.                                                
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Apr 14 2013 - 18:56:56 CEST

Original text of this message