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

Home -> Community -> Usenet -> c.d.o.server -> Migrating to cost based optimizer

Migrating to cost based optimizer

From: <hasta_l3_at_hotmail.com>
Date: 23 Sep 2006 01:37:59 -0700
Message-ID: <1159000679.064237.120730@m73g2000cwd.googlegroups.com>


Dear group,

Our applications are supporting Oracle 8.1.7 and Oracle 9, for many customers with varying level of activity. We use the rule based optimizer to ensure the stability of the sql statement's execution plans.

We are thinking of moving to the cost based optimizer, at least in Oracle 10.

Would you have a strategy to recommand ?

What is the first Oracle release with a cost based optimizer working reasonably well ?

How do you check the performances of your applications across oracle releases and customers with that optimizer ?

Thanks. Received on Sat Sep 23 2006 - 03:37:59 CDT

Original text of this message

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