RE: Stored Outlines and Optimizer Mode

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Thu, 18 Mar 2004 14:37:29 -0800
Message-ID: <35CFD500D7BDCE43B9030BBA5979DC181D93F4@ussccem13.hds.com>

Paula,

In addition to this (i.e. CBO kicking in for SQLs with SP), there are other situations where the CBO will kick in as well. This is documented in the Tuning guide, but you might find a useful summary of it in my IOUG paper - check out http://www.geocities.com/john_sharmila/links.htm - click on "IOUG 2002 Paper - Safely navigating the RBO to CBO minefield".

Hth,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com

The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paula Winkler
Sent: Thursday, March 18, 2004 1:35 PM
To: oracle-l_at_freelists.org
Subject: RE: Stored Outlines and Optimizer Mode

Thank you Niall and Lex for your responses.

We have a 3rd-party Oracle8i system running under the RULE-based optimizer. We have identified a handful of poor performing SQLs. We can't change the generated SQLs therefore we are looking into using stored outlines to store the access plans for those exceptional SQLs. Our thought is CBO would kick in for the SQLs with the stored outlines and RBO would kick in for the other acceptable SQLs. Does this sound like it will work?

Paula W.

Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Thu Mar 18 2004 - 16:41:33 CST