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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
