Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: performance in 10g

RE: performance in 10g

From: David Boyd <davidb158_at_hotmail.com>
Date: Thu, 25 Jan 2007 09:10:15 -0500
Message-ID: <BAY101-F128C48E3E263532395B3E4EFA30@phx.gbl>


Riaz,

Thanks for your quick response. We do have the latest stats in place.

Dave

>Gather the objects statistics first using DBMS_STATS which will help you
>to improve the performance a lot. Because, no RBO in oracle 10g and the
>optimizer will give you the optimized plan if your db should have the
>latest stats.



Search for grocery stores. Find gratitude. Turn a simple search into something more.
http://click4thecause.live.com/search/charity/default.aspx?source=hmemtagline_gratitude&FORM=WLMTAG
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 25 2007 - 08:10:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US