Sorry, but maybe you refer to the outlines and the
parameter use_stored_outlines. Read the notes
1071358.6 and 92202.1
Regards.
--- "C.S.Venkata Subramanian" <[EMAIL PROTECTED]>
wrote:
> 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).
=====
Eng. Christian Trassens
Senior DBA
Systems Engineer
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : 541149816062
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christian Trassens
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).
