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: RULE and partitions

Re: RULE and partitions

From: Paul Drake <bdbafh_at_gmail.com>
Date: Wed, 3 May 2006 13:53:45 -0400
Message-ID: <910046b40605031053j2b83d3d4w3610aedfa5ea99fc@mail.gmail.com>


On 5/3/06, Dennis Williams <oracledba.williams_at_gmail.com> wrote:
>
> List,
> Does anyone have any experience running OPTIMIZER_MODE=RULE, with some
> tables partitioned in Oracle9i?
> I have an application on Oracle 8.1.7.4. The vendor specifies
> OPTIMIZER_MODE=RULE. The vendor supports Oracle9i with this version of the
> application. I have a lot of data stored in this application. I would like
> to upgrade the database to 9i so I could partition some of the large tables
> for manageability. I realize that the RBO is not aware of partitions. This
> is an OLTP application that uses indexes for all data accesses, so I
> wouldn't expect any differences. Eventually the application will be upgraded
> to a version that supports CBO, but that will take a couple of years to roll
> out. Just looking at what I can do in the meanwhile.
>
> Dennis Williams
>

C'mon Dennis. Live a little. Upgrade straight to 10.2.0.1 and apply 10.2.0.2 .
You know that you want to.
Then have a look at optimizer-mode='FIRST_ROWS_10'.

refer to Appendix A - Upgrade Headaches of Jonathan Lewis' Cost-Based Oracle Fundementals

hth.

Paul

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 03 2006 - 12:53:45 CDT

Original text of this message

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