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 vs. CHOOSE

Re: RULE vs. CHOOSE

From: C.S.Venkata Subramanian <csvenkata_at_lycos.com>
Date: Wed, 01 Aug 2001 02:28:29 -0700
Message-ID: <F001.0035B7C0.20010801022520@fatcity.com>

Use the plan stability of Oracle 8i. In this u have to capture plans for the sqls. A init parameter has to be added use_plan_stability=true(pls chk with manuals for more info).  

Ref to Oracle performance tuning manual. It is explained well there.

HTH
Regards
Venkat

--

On Tue, 31 Jul 2001 23:05:27  
 VIVEK_SHARMA wrote:

>
>Qs. Will COST Based Optimizer (CBO) or Rule Based Optimizer (RBO) be
>used for the PARTITIONED Table in the Following Query ?
>
>NOTE OPTIMIZER_MODE is Set Explicitly to RULE , Run the Following SQL :-
>
>SELECT <Some Columns>
>FROM <Partition Table> , <NON-Partitioned Table>
>where <Partition Table>.Column = <NON-Partitioned Table>.Column
>
>Assuming <Partition Table>.Column is the PARTITION KEY
>& BOTH <Partition Table> & <NON-Partitioned Table> are ANALYZED .
>
>Qs. Will Only the Respective partition be SCANNED in the Above Query ?
>Qs. Would there be Any Disadvantage in SETTING OPTIMIZER_MODE=RULE for
>the Above Query ?
>
>Most of the Tables in the Application may be NON-partitioned & Most of
>the Queries RUN Well in RULE .
>
>
>
>
>Qs. How is it Best Possible to KEEP the SAME (BEST) Execution Plan at
>Various Sites where the SAME PRODUCT Exists
>
>NOTE - These Sites Belong to DIFFERENT Customers & Have Different Total
>Data Size & Distributions .
>
>Current Data Size ranges from 50 to 150 GB but the Data is Growing Very
>Rapidly & may touch 200 GB within the Year .
>
>Being a Banking Application Product , it is a MIX of OLTP & DSS Types
>of Transactions .
>
>With OPTIMIZER_MODE set to RULE the Queries work Quite Well .
>
>
>Qs. Is there any PACKAGE etc. which Automatically Causes Statistics to
>be ANALYZED in some SMALL proportions (Bit by Bit) while Live Operations
>are in progress ? What would be the Overhead of Such a Package (if
>Exists) ?
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: VIVEK_SHARMA
> INET: VIVEK_SHARMA_at_infy.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: csvenkata_at_lycos.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Received on Wed Aug 01 2001 - 04:28:29 CDT

Original text of this message

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